passing multiple records to json_populate_recordset

From: Raphael Bauduin <rblists(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: passing multiple records to json_populate_recordset
Date: 2013-09-23 09:31:40
Message-ID: CAONrwUFbuBBUCm+jNNpU7LQ1SV-5O4SWWpX8fFq6ujBcRvwN8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm experimenting with the json data type and functions in 9.3.
I'm storing json objects of this form in the event column:
{type: 'event_type, products : [ {id:45, 'type': 3, 'gender':'F',..}, ...,
{....} ] }

I can issue this query, but notice the limit 1:

select * from json_populate_recordset(null::product, (select
event->'products' from events limit 1));

The result is:

type | gender | id
------+--------+-------
41 | F | 40003
41 | F | 60043
41 | F | 27363
41 | F | 27373
41 | F | 28563

But all these products come from one event.
Is there a way to return the products from several events?, eg with a limit
2 rather than limit 1?

Thanks

Raph

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rémi Cura 2013-09-23 13:16:37 Re: Tree structure
Previous Message Kaare Rasmussen 2013-09-23 04:48:54 Re: Tree structure