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 по дате отправления: