big thanks, this is exactly what i was looking for.
jan
Am 13.08.2012 um 17:58 schrieb Merlin Moncure :
> On Sat, Aug 11, 2012 at 7:05 AM, jan zimmek wrote:
>> hi,
>>
>> i am looking into json support of the upcoming 9.2 release and have a
>> question about the row
ot;:1,"project_name":"prj1"}}
i thought of something like this:
select
row_to_json(t1)
from (
select
'joe' as username,
(select * from (values(1, 'prj1')) as project(project_id, project_name)) as
project
) t1;
but this fails with "ERROR: s
