Re: PATCH: Add hstore_to_json()
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: "David E. Wheeler" <david@kineticode.com>
Cc: Andrew Dunstan <andrew@dunslane.net>,
Hitoshi Harada <umi.tanuki@gmail.com>, Peter Eisentraut <peter_e@gmx.net>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2010-01-05T04:18:36Z
Lists: pgsql-hackers
On Sun, Jan 3, 2010 at 1:51 PM, David E. Wheeler <david@kineticode.com> wrote: > On Jan 3, 2010, at 8:00 AM, Andrew Dunstan wrote: > >> I think the minimal functionality I'd want is: >> >> convert record to JSON >> convert JSON to record > > With caveats as to dealing with nested structures (can a record be an attribute of a record?). > >> extract a value, or set of values, from JSON >> composition of JSON > > There's a lot of functionality in hstore that I'd like to see. It'd make sense to use the same operators for the same operations. I think I'd start with hstore as a basic spec. David, Is this something you are planning to work on for the 2010-01-15 CommitFest? If not, I think we should go ahead and mark the patch which was the original subject of this thread "Returned with Feedback", as it does not seem to make sense to add it unless we add a json type first. Thoughts? ...Robert