Examples of how to join relational data

[apache]

Examples of how to join relational data

[JoshInnis]

https://age.apache.org/docs/Apache_AGE_Guide.pdf

In the above link, there is a section called "Advanced Queries" where there is a simple example about how to join Postgres tables.

[jhgoodwin]

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:

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.