Re: jsonb_set() strictness considered harmful to data

Поиск
Список
Период
Сортировка
От Maurice Aubrey
Тема Re: jsonb_set() strictness considered harmful to data
Дата
Msg-id CAMjjn=FcMdecBzzozUvSDq4iAUum4D=2Y5yNfhnMbuaty4FxTQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: jsonb_set() strictness considered harmful to data  (Stuart McGraw <smcg4191@mtneva.com>)
Список pgsql-general


On Wed, Oct 23, 2019 at 12:01 PM Stuart McGraw <smcg4191@mtneva.com> wrote:
When examples are given, they typically are with scalar values where
such behavior makes sense: the resulting scalar value has to be NULL
or non-NULL, it can't be both.

It is less sensible with compound values where the rule can apply to
individual scalar components.  And indeed that is what Postgresql does
for another compound type:

I agree completely. Scalar vs compound structure seems like the essential difference.
You don't expect an operation on an element of a compound structure to be able to effect the entire structure.
Maurice

В списке pgsql-general по дате отправления:

Предыдущее
От: rob stone
Дата:
Сообщение: Re: jsonb_set() strictness considered harmful to data
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Composite type storage overhead