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/02/22 18:30:05 UTC
[GitHub] [incubator-age] jrgemignani removed a comment on issue #189: Match with order by can not return the node
jrgemignani removed a comment on issue #189:
URL: https://github.com/apache/incubator-age/issues/189#issuecomment-1048089269
The later does work -
> ```
> SELECT * from cypher('agegraph', $$ MATCH (n) RETURN n ORDER BY n.id $$) as (n agtype);
> ```
>
> Tried, but still not work . Thanks for your rsp
```
psql-11.5-5432-pgsql=# SELECT * from cypher('cypher_vle', $$ MATCH (n) RETURN n ORDER BY n.id $$) as (n agtype);
n
-----------------------------------------------------------------------
{"id": 844424930131969, "label": "begin", "properties": {}}::vertex
{"id": 1407374883553281, "label": "middle", "properties": {}}::vertex
{"id": 1407374883553282, "label": "middle", "properties": {}}::vertex
{"id": 1407374883553283, "label": "middle", "properties": {}}::vertex
{"id": 1688849860263937, "label": "end", "properties": {}}::vertex
(5 rows)
psql-11.5-5432-pgsql=# SELECT * from cypher('cypher_vle', $$ MATCH (n) RETURN n ORDER BY id(n) $$) as (n agtype);
n
-----------------------------------------------------------------------
{"id": 844424930131969, "label": "begin", "properties": {}}::vertex
{"id": 1407374883553281, "label": "middle", "properties": {}}::vertex
{"id": 1407374883553282, "label": "middle", "properties": {}}::vertex
{"id": 1407374883553283, "label": "middle", "properties": {}}::vertex
{"id": 1688849860263937, "label": "end", "properties": {}}::vertex
(5 rows)
psql-11.5-5432-pgsql=#
```
--
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