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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers