Postgres Pro
Downloads
Home   >   mailing lists

Re: append jsonb array to another jsonb array - Mailing list pgsql-general

From Pavel Stehule
Subject Re: append jsonb array to another jsonb array
Date
Msg-id CAFj8pRAdVkdpo105L3nC5z1cYAaHgHummrVgarn54g6F-yJ1eg@mail.gmail.com
Whole thread Raw
In response to append jsonb array to another jsonb array  (Joao Miguel Ferreira <joao.miguel.c.ferreira@gmail.com>)
Responses Re: append jsonb array to another jsonb array
List pgsql-general
Tree view
Hi

st 17. 2. 2021 v 20:44 odesílatel Joao Miguel Ferreira <joao.miguel.c.ferreira@gmail.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


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: append jsonb array to another jsonb array
Next
From: Joao Miguel Ferreira
Date:
Subject: Re: append jsonb array to another jsonb array