jhgoodwin commented on issue #47:
URL: https://github.com/apache/incubator-age/issues/47#issuecomment-803168663
Thanks for the guide @JoshInnis . That got me pretty close to what I was
looking for. Looks like many type conversions are not yet supported - a pity.
I was able to figure this out, which does work:
```sql
WITH graph_query as (
SELECT *
FROM cypher( 'test_graph', $$MATCH (n) RETURN n.part_num$$
) as (part_num text)
)
SELECT (g.part_num::json)#>> '{}' as part_num
FROM graph_query g
WHERE g.part_num = '"123"'
;
```
This will deconstruct the string value of 123 from the row. Feels like there
probably is a simpler way. Maybe you know it.
From here, joining against a relational table should be trivial. Looks like
part of what I was missing before is the as clause with the parenthesis syntax
is how you define the row datatype of the cypher function.
--
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.
For queries about this service, please contact Infrastructure at:
[email protected]
