Hector Menchaca wrote
> json_array_elements(ResourceDocument->'Skill'->*)
NOT TESTED (or complete)
SELECT skill_type.value->'Name'
FROM (
SELECT * FROM json_each(rd->'Skill')
) skill_type
Because you want columns for Name, etc, you must list those explicitly
instead of using json_each over those.
David J.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgres-json-How-to-query-map-keys-to-get-children-tp5816001p5816009.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.