Re: Avoid undesired flattening of jsonb arrays?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Avoid undesired flattening of jsonb arrays?
Дата
Msg-id CAKFQuwYAjzoDtUdXz03K-Cs8UDG9TKkdQLRAWAxFc2kGwMr0_A@mail.gmail.com
обсуждение исходный текст
Ответ на Avoid undesired flattening of jsonb arrays?  ("Joel Jacobson" <joel@compiler.org>)
Ответы Re: Avoid undesired flattening of jsonb arrays?
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: "Joel Jacobson"
Дата:
Сообщение: Avoid undesired flattening of jsonb arrays?
Следующее
От: Lars Vonk
Дата:
Сообщение: Missing rows after migrating from postgres 11 to 12 with logical replication