append jsonb array to another jsonb array

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

append jsonb array to another jsonb array

Joao Miguel Ferreira-3
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 ?

thanks
João


Reply | Threaded
Open this post in threaded view
|

Re: append jsonb array to another jsonb array

David G Johnston


On Wednesday, February 17, 2021, Joao Miguel Ferreira <[hidden email]> wrote:
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 ?

That’s called concatenation.


David J.
Reply | Threaded
Open this post in threaded view
|

Re: append jsonb array to another jsonb array

Pavel Stehule
In reply to this post by Joao Miguel Ferreira-3
Hi

st 17. 2. 2021 v 20:44 odesílatel Joao Miguel Ferreira <[hidden email]> 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


Reply | Threaded
Open this post in threaded view
|

Re: append jsonb array to another jsonb array

Joao Miguel Ferreira-3
Hi, David, Pavel,

Thank you for your indications

Joao


On Wed, Feb 17, 2021 at 7:50 PM Pavel Stehule <[hidden email]> wrote:
Hi

st 17. 2. 2021 v 20:44 odesílatel Joao Miguel Ferreira <[hidden email]> 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