Re: JSON for PG 9.2 - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: JSON for PG 9.2
Date
Msg-id CAFj8pRC23e-zaj=0Z2_kTTWrxzSTZtU07UgS7de8MMheeyTuAw@mail.gmail.com
Whole thread Raw
In response to Re: JSON for PG 9.2  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
2012/1/12 Merlin Moncure <mmoncure@gmail.com>:
> On Thu, Jan 12, 2012 at 9:51 AM, Andrew Dunstan <andrew@dunslane.net> wrote:
>> On 01/12/2012 10:44 AM, Pavel Stehule wrote:
>>> this should be little bit more enhanced to support a row arrays - it
>>> can be merged with some routines from pst tool
>>> http://okbob.blogspot.com/2010/11/new-version-of-pst-collection-is.html
>>
>> I will be covering composites.
>
> curious, will your function work on unregistered composites?  What
> would this do?
>
> select array_to_json(array[row('a', 1), row('b', 2)]);

it can do it - but it has to use some defaults for names.

Pavel

>
> merlin


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgbench post-connection command
Next
From: Andrew Dunstan
Date:
Subject: Re: JSON for PG 9.2