Re: postgres json: How to query map keys to get children

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: postgres json: How to query map keys to get children
Date: 2014-08-23 20:18:52
Message-ID: 1408825132229-5816009.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Hector Menchaca 2014-08-23 23:38:39 Re: postgres json: How to query map keys to get children
Previous Message Hector Menchaca 2014-08-23 18:02:37 postgres json: How to query map keys to get children