Re: append jsonb array to another jsonb array

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Joao Miguel Ferreira <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: append jsonb array to another jsonb array
Date: 2021-02-17 19:50:16
Message-ID: CAKFQuwbGu7cto8p5my05HKjFiPf65m8rKjSF-Vi3sgBndZYJ3A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, February 17, 2021, Joao Miguel Ferreira <
joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)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.

https://www.postgresql.org/docs/11/functions-json.html

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2021-02-17 19:50:17 Re: append jsonb array to another jsonb array
Previous Message Joao Miguel Ferreira 2021-02-17 19:44:32 append jsonb array to another jsonb array