WendelLana commented on PR #910: URL: https://github.com/apache/age/pull/910#issuecomment-1644591507
I'm referring to this [issue](https://github.com/neo4j/neo4j/issues/1058) that shows one use case. I believe we could use it in some scenarios, for instance, when dividing by zero. Consider the following Cypher query: ```` MATCH (n)-[]->(m) RETURN n.value / nullif (m.value, 0) ```` Additionally, I find this command: ```` RETURN NULLIF(n.value, m.value) ```` to be better and less verbose than: ```` RETURN CASE n.value = m.value THEN NULL ELSE n.value ```` I know it may seem like a very specific case, but I genuinely think having a function like Postgres' `NULLIF` is beneficial as it promotes more integration between SQL and Cypher. This permits a simpler logic when writing a Cypher query using SQL-like logic. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
