From: | sighup <rts(at)sighup(dot)eu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Returning values from an array of JSONB objects. |
Date: | 2016-04-13 10:30:34 |
Message-ID: | 570E1FCA.90200@sighup.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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": 8,
"done": 0}, {"idle": true, "items": 8, "done": 0}]') ;
How can I extract the value of the 'items' key either as two rows and or
a sum of both.
I had thought that :
SELECT Markers->'items' AS Items FROM Data WHERE (ID = X) ;
would have done the job but all I get is an empty column, of course using :
SELECT Markers->0->'items' AS Items FROM Data WHERE (ID = X) ;
Produces a single row but isn't exactly what I want. I have of course
searched but not found a definitive answer, or maybe that should read
'one I can understand'.
I'm using PostgreSQL 9.5 on Linux with pgAdmin III on Mac.
--
Bill
From | Date | Subject | |
---|---|---|---|
Next Message | Vitaly Burovoy | 2016-04-13 10:42:30 | Re: Returning values from an array of JSONB objects. |
Previous Message | Alexander Pyhalov | 2016-04-13 06:30:54 | Re: pgpool-II: cannot use serializable mode in a hot standby |