[GitHub] [age] humzakt commented on issue #988: Unexpected output from MATCH RETURN query when nodes don't have a specific property

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

humzakt commented on issue #988:
URL: https://github.com/apache/age/issues/988#issuecomment-1592471718

   As discussed in the above answers, it is the expected behavior of the cypher query. You can study more about cypher queries in the [Documentation](http://age.apache.org/).
   If you want to filter out the nodes that don't have the 'com' property, you could use a WHERE clause to do this:
   
   ```
   demo=# SELECT *
   FROM cypher('demo', $$
   MATCH (u)
   WHERE u.com IS NOT NULL
   RETURN u.com
   $$) as (a agtype);
   
   ```
   
   This will only return nodes that have the 'com' 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