Postgres Pro
Downloads
Home   >   mailing lists

Re: Avoid undesired flattening of jsonb arrays? - Mailing list pgsql-general

From David G. Johnston
Subject Re: Avoid undesired flattening of jsonb arrays?
Date
Msg-id CAKFQuwYAjzoDtUdXz03K-Cs8UDG9TKkdQLRAWAxFc2kGwMr0_A@mail.gmail.com
Whole thread Raw
In response to Avoid undesired flattening of jsonb arrays?  ("Joel Jacobson" <joel@compiler.org>)
Responses Re: Avoid undesired flattening of jsonb arrays?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
On Fri, Dec 18, 2020 at 8:24 AM Joel Jacobson <joel@compiler.org> wrote:
The || operator for the jsonb type has a surprising behaviour.

Instead of appending the right operand "as is" to the left operand,
it has a magic behaviour if the right operand is an array,
in which case it will append the items of the array,
instead of appending the array itself as a single value.


It's not magic, and it is documented clearly.

I'll agree that the description could discuss the case explicitly, and the array||scalar case could be added to the examples.


Suggestions welcome if there is a better way to solve this problem.


As you are writing literals just put an array in the to-be-merged array.

select '["a","b"]'::jsonb || '[["c","d"]]'::jsonb

David J.

pgsql-general by date:

Previous
From: "Joel Jacobson"
Date:
Subject: Avoid undesired flattening of jsonb arrays?
Next
From: Lars Vonk
Date:
Subject: Missing rows after migrating from postgres 11 to 12 with logical replication