[GitHub] [age] WendelLana opened a new issue, #908: NULLIF() function

["WendelLana (via GitHub)" <gi...@apache.org>]

WendelLana opened a new issue, #908:
URL: https://github.com/apache/age/issues/908

   **Is your feature request related to a problem? Please describe.**
   I was trying to create a conditional statement using the `NULLIF()` function inside a Cypher query, but I received an error message stating that the function does not exist.
   
   
   **Describe the solution you'd like**
   A similar function to the PG `NULLIF()` function
   
   **Describe alternatives you've considered**
   Using `CASE` would be an alternative to `NULLIF`
   
   **Additional context**
   I'm working on a PR for this, if there's no problem
   


-- 
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: dev-unsubscribe@age.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [age] farakh-shahid commented on issue #908: NULLIF() function

["farakh-shahid (via GitHub)" <gi...@apache.org>]

farakh-shahid commented on issue #908:
URL: https://github.com/apache/age/issues/908#issuecomment-1552567303

   Yes i have checked this We have alternative CASE .
   We can achieve similar functionality  using the 'CASE' expression in cypher.
   
   Try this :
   ```
   MATCH  (n:node)
   RETURN CASE
   WHEN n.property = 'value' THEN NULL
   ELSE n.property
   END AS result;
   ```
   
   This will is  n.property has a value of 'value' then it will return null for this  else it will return n.property.


-- 
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: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org