Horton
Menu

Re: PATCH: Add hstore_to_json()

David E. Wheeler <david@kineticode.com>

View thread
From: "David E. Wheeler" <david@kineticode.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Hitoshi Harada <umi.tanuki@gmail.com>, Peter Eisentraut <peter_e@gmx.net>, Robert Haas <robertmhaas@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2010-01-03T18:51:22Z
Lists: pgsql-hackers 
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.

Best,

David