You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by GitBox <gi...@apache.org> on 2022/11/12 12:59:28 UTC
[GitHub] [age] djskl opened a new issue, #351: why can't "WHERE" work with 'MATCH' ?
djskl opened a new issue, #351:
URL: https://github.com/apache/age/issues/351
I tried the "WITH" cluse as described by the doc [Filter on aggregate function results](https://age.apache.org/age-manual/master/clauses/with.html#filter-on-aggregate-function-results). But, I found that the condition presented by 'where' can't work with 'match'.
Example Code:
`select * from cypher('agload_test_graph', $$ match (n) with n where n.name='A' return n $$) as (sp agtype)`
the `n.name='A'` doesn't work.
If "with" are removed, 'where' can then work:
`select * from cypher('agload_test_graph', $$ match (n) where n.name='A' return n $$) as (sp agtype)`
--
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] jrgemignani closed issue #351: why can't "WHERE" work with 'MATCH/WITH' ?
Posted by "jrgemignani (via GitHub)" <gi...@apache.org>.
jrgemignani closed issue #351: why can't "WHERE" work with 'MATCH/WITH' ?
URL: https://github.com/apache/age/issues/351
--
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
[GitHub] [age] jrgemignani commented on issue #351: why can't "WHERE" work with 'MATCH' ?
Posted by GitBox <gi...@apache.org>.
jrgemignani commented on issue #351:
URL: https://github.com/apache/age/issues/351#issuecomment-1325648320
Hmmmm,...
```
psql-11.5-5432-pgsql=# select * from cypher('graph', $$ match (n) return n $$) as (sp agtype);
sp
------------------------------------------------------------------------------
{"id": 281474976710657, "label": "", "properties": {"name": "John"}}::vertex
{"id": 281474976710658, "label": "", "properties": {"name": "Mary"}}::vertex
(2 rows)
psql-11.5-5432-pgsql=# select * from cypher('graph', $$ match (n) with n where n.name='John' return n $$) as (sp agtype);
sp
------------------------------------------------------------------------------
{"id": 281474976710657, "label": "", "properties": {"name": "John"}}::vertex
{"id": 281474976710658, "label": "", "properties": {"name": "Mary"}}::vertex
(2 rows)
psql-11.5-5432-pgsql=# select * from cypher('graph', $$ match (n) where n.name='John' return n $$) as (sp agtype);
sp
------------------------------------------------------------------------------
{"id": 281474976710657, "label": "", "properties": {"name": "John"}}::vertex
(1 row)
psql-11.5-5432-pgsql=#
```
We will need to look into this.
--
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