Hi,
I need to construct this type of query:
SELECT
t.id, array_agg("data"."_rowId"), t.name
FROM "data"
CROSS JOIN
json_to_recordset("data"."habitas") as t("id" text, "name" text)
GROUP BY t.id, t.name
All fine except for the 'json_to_recordset("data"."habitas") as t("id" text,
"name" text)' bit which I can't work out how to achieve in jOOQ.
Are there any examples on how to call a Postgres function that returns a
recordset or rowtyped value?
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
