On Mon, Dec 7, 2020 at 6:13 PM Rob Sargent <robjsarg...@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.
