Re: passing multiple records to json_populate_recordset

On 09/23/2013 06:25 AM, Raphael Bauduin wrote:
>
>
> Some more info, after searching further.
>
> This query
>
> select
> json_populate_record(null::product,row_to_json(json_populate_recordset(null::product,event->'products')))
> from (select * from events limit 2) as foo ;
>
> returns what I want but not in the format I want (why?):

Maybe try:

select * from
json_populate_record(null::product,row_to_json(json_populate_recordset(null::product,event->'products')))
from (select * from events limit 2) as foo ;

>
> Raph

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com