Re: [GENERAL] returning json object with subset of keys

2014-01-09 Thread Merlin Moncure
On Thu, Jan 9, 2014 at 1:42 AM, Raphael Bauduin wrote: > On Wed, Jan 8, 2014 at 4:05 PM, Merlin Moncure wrote: >> >> On Wed, Jan 8, 2014 at 6:37 AM, Raphael Bauduin wrote: >> > Hi >> > >> > I'm using the json functionalities of postgresql 9.3. >> > I have a query calling json_populate_recordset

Re: [GENERAL] returning json object with subset of keys

2014-01-08 Thread Raphael Bauduin
On Wed, Jan 8, 2014 at 4:05 PM, Merlin Moncure wrote: > On Wed, Jan 8, 2014 at 6:37 AM, Raphael Bauduin wrote: > > Hi > > > > I'm using the json functionalities of postgresql 9.3. > > I have a query calling json_populate_recordset like this: > > json_populate_recordset(null::product, event->'p

Re: [GENERAL] returning json object with subset of keys

2014-01-08 Thread Merlin Moncure
On Wed, Jan 8, 2014 at 6:37 AM, Raphael Bauduin wrote: > Hi > > I'm using the json functionalities of postgresql 9.3. > I have a query calling json_populate_recordset like this: > json_populate_recordset(null::product, event->'products') > but it returns an error: > ERROR: cannot call json_popu

[GENERAL] returning json object with subset of keys

2014-01-08 Thread Raphael Bauduin
Hi I'm using the json functionalities of postgresql 9.3. I have a query calling json_populate_recordset like this: json_populate_recordset(null::product, event->'products') but it returns an error: ERROR: cannot call json_populate_recordset on a nested object There is indeed one key in event->