Re: Extracting data from jsonb array? - Mailing list pgsql-general

From Rob Sargent
Subject Re: Extracting data from jsonb array?
Date
Msg-id f2651149-c274-3cea-651d-891f71843960@gmail.com
Whole thread Raw
In response to Re: Extracting data from jsonb array?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Extracting data from jsonb array?
List pgsql-general


On 12/7/20 6:17 PM, David G. Johnston wrote:
On Mon, Dec 7, 2020 at 6:13 PM Rob Sargent <robjsargent@gmail.com> wrote:


postgres=# select id, array_agg(fa) from (select id, (jsonb_array_elements(js)->'key') as fa from foo) g group by id order by id;
 id |          array_agg          
----+------------------------------
  1 | {"\"r1kval\"","\"r1kval2\""}
  2 | {"\"r2kval\"","\"r2kval2\""}
(2 rows)

I think the quotes are a fault of example data?  

The quotes are the fault of the query author choosing the "->" operator instead of "->>".

David J.
With that correction OP might have an answer?

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Extracting data from jsonb array?
Next
From: Ken Tanzer
Date:
Subject: Re: Extracting data from jsonb array?