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

From Joao Miguel Ferreira
Subject append jsonb array to another jsonb array
Date
Msg-id CALyyT7SdxPpF8PhvTpdNAjBvY2JdZLxA-zrGdm1D1VfPryvSPQ@mail.gmail.com
Whole thread Raw
Responses Re: append jsonb array to another jsonb array  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: append jsonb array to another jsonb array  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Paul van der Linden
Date:
Subject: Re: Slow index creation
Next
From: "David G. Johnston"
Date:
Subject: Re: append jsonb array to another jsonb array