Re: append jsonb array to another jsonb array

Hi

st 17. 2. 2021 v 20:44 odesílatel Joao Miguel Ferreira <
joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> napsal:

> Hello all,
>
> I PL/pgSQL I have a few jsonb variables (instantiated each with an array
> of objects) and I need to append them to produce the final result. All of
> them are small in size (max 30 each). We are using Pg 11.
>
> Example:
> a = [ x, y ]
> b = [ z , w ]
> result would be [ x, y, z, w ]
>
> What would you consider to be a suitable approach ?
>

postgres=# select '[10,20,30]'::jsonb || '[100,20]'::jsonb;
┌───────────────────────┐
│ ?column? │
╞═══════════════════════╡
│ [10, 20, 30, 100, 20] │
└───────────────────────┘
(1 row)

Regards

Pavel

> thanks
> João
>
>
>