Re: [GENERAL] Returning values from an array of JSONB objects.

2016-04-13 Thread sighup
On 13/04/2016 11:53, Vitaly Burovoy wrote: On 4/13/16, Vitaly Burovoy wrote: On 4/13/16, sighup wrote: Hi, please excuse either my stupidity or naivety regarding this but I'm a bit confused. Give the following basic table structure : TABLE Data ( ID INT NOT NULL, Ma

[GENERAL] Returning values from an array of JSONB objects.

2016-04-13 Thread sighup
Hi, please excuse either my stupidity or naivety regarding this but I'm a bit confused. Give the following basic table structure : TABLE Data ( ID INT NOT NULL, Markers jsonb NOT NULL ); And the following data: INSERT INTO Data (ID, Markers) VALUES(1, '[ {"idle": true, "items":