[GitHub] [age] kenwoon commented on issue #951: How to use WHERE caluse after a (WITH .. AS ...)

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

kenwoon commented on issue #951:
URL: https://github.com/apache/age/issues/951#issuecomment-1566612988

   It seems like AGE does not yet support filtering on patterns with properties. According to the [Neo4j documentation](https://neo4j.com/docs/cypher-manual/current/clauses/where/#filter-on-patterns-with-properties) for the `WHERE` clause, properties can also be added as patterns, as such:
   
   ```
   MATCH (n:Person)
   WHERE (n)-[:KNOWS]-({name: 'Timothy'})
   RETURN n.name, n.age
   ```
   
   However, this returns the following error in AGE:
   
   ```
   ERROR:  syntax error at or near ":"
   LINE 3: WHERE (n)-[:KNOWS]-({name: 'Timothy'})
                      ^
   ```
   
   You would have to find a different way to set the filter by using a different clause or changing the contents for your `WHERE` clause. Refer to the documentation earlier for a guide on using the clause.


-- 
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