Re: JSON for PG 9.2

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.

cheers

andrew