Andrew,
What about doing:
json_get(json, json)
returns json
where parameter #2 is a path expressed as JSON? For example,
json_get(personal_profile, '[ {contact_info {phone numbers {cell phones}
} } ]')
... would return whatever was in that heirarchical object, in this case
an array of cell phone numbers.
Or am I just reinventing jsonpath?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com