Home > mailing lists

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

From	David G. Johnston
Subject	Re: append jsonb array to another jsonb array
Date	February 17, 2021 22:50:16
Msg-id	CAKFQuwbGu7cto8p5my05HKjFiPf65m8rKjSF-Vi3sgBndZYJ3A@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>)
List	pgsql-general

On Wednesday, February 17, 2021, Joao Miguel Ferreira <joao.miguel.c.ferreira@gmail.com> 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.

From: Joao Miguel Ferreira
Date: 17 February 2021, 22:44:32
Subject: append jsonb array to another jsonb array

From: Pavel Stehule
Date: 17 February 2021, 22:50:17
Subject: Re: append jsonb array to another jsonb array