GitHub user jrgemignani added a comment to the discussion: Simplify this query
and remove redundancy
Not sure what to tell you -
```
psql-17.6-5432-pgsql=# load 'age'; set search_path = ag_catalog;
LOAD
SET
psql-17.6-5432-pgsql=# select * from cypher('graph', $$ match (b:Book) return
pg_catalog.json_build_object(label(b)::text, b.title::text) $$) as (result
json);
result
------------------
{"Book" : "Qrs"}
{"Book" : "Qrs"}
{"Book" : "Qrs"}
{"Book" : "Xyz"}
{"Book" : "Abc"}
{"Book" : "Abc"}
{"Book" : "Abc"}
(7 rows)
psql-17.6-5432-pgsql=# select * from cypher('graph', $$ match (b:Book) return
pg_catalog.json_build_object(label(b)::text, b.junk::text) $$) as (result json);
result
-----------------
{"Book" : null}
{"Book" : null}
{"Book" : null}
{"Book" : null}
{"Book" : null}
{"Book" : null}
{"Book" : null}
(7 rows)
psql-17.6-5432-pgsql=#
```
Which PG/AGE version are you using?
GitHub link:
https://github.com/apache/age/discussions/2226#discussioncomment-14556835
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
