Re: PATCH: Add hstore_to_json()

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>
To: "David E. Wheeler" <david@kineticode.com>
Cc: Peter Eisentraut <peter_e@gmx.net>, Robert Haas <robertmhaas@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2009-12-31T16:12:54Z
Lists: pgsql-hackers

David E. Wheeler wrote:
> On Dec 31, 2009, at 1:04 AM, Peter Eisentraut wrote:
>
>   
>> I think the primary use will be to load a JSON value into Perl or Python
>> and process it there.  So a json type that doesn't have any interesting
>> operators doesn't sound useless to me.  The features I would like to get
>> out of it are input validation and encoding handling and smooth
>> integration with said languages.
>>     
>
> What about access to various parts of a JSON data structure? Or is that just asking for too much trouble up-front?
>
>
>   

IMNSHO it's essential. I think Peter's approach of ignoring this 
requirement is extremely shortsighted.

cheers

andrew