On 01/11/2012 10:21 AM, Pavel Stehule wrote:
> 2012/1/11 Robert Haas<robertmhaas(at)gmail(dot)com>:
>> On Wed, Jan 11, 2012 at 9:41 AM, Pavel Stehule<pavel(dot)stehule(at)gmail(dot)com> wrote:
>>> I understand it now. My opinion is so some operators and index search
>>> can be in 9.2 - so use a JSON just as communication format now.
>>> * we need to build JSON
>>> * we need to check if some is valid JSON
>>> * we need to store JSON
>>> other steps should be (9.2)
>>> * basic operators eq, neeq
>>> * some tool like XQuery - simple query on JSON document available from
>>> SQL that can be used for functional indexes.
>> That would be nice, but let's not let the perfect be the enemy of the
>> good. We don't have a lot of time here.
> sorry - replace 9.2 by 9.3 - I am sorry
> I am able to write array_to_json fce and Andrew can write query_to_json
For those who want to play along, see
<https://bitbucket.org/adunstan/pgdevel> which has Robert's patch and my
additions to it.
I'm actually half way through writing an array_to_json function, since
it it necessary anyway for query_to_json. I hope to have a fairly
complete working function in about 24 hours.
In response to
pgsql-hackers by date
|Next:||From: Andrew Hammond||Date: 2012-01-12 00:57:34|
|Subject: order of operations for pg_restore|
|Previous:||From: Tom Lane||Date: 2012-01-12 00:43:02|
|Subject: Re: Remembering bug #6123 |