Re: jsonb_set() strictness considered harmful to data - Mailing list pgsql-general

From Maurice Aubrey
Subject Re: jsonb_set() strictness considered harmful to data
Date
Msg-id CAMjjn=FcMdecBzzozUvSDq4iAUum4D=2Y5yNfhnMbuaty4FxTQ@mail.gmail.com
Whole thread Raw
In response to Re: jsonb_set() strictness considered harmful to data  (Stuart McGraw <smcg4191@mtneva.com>)
List 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 by date:

Previous
From: rob stone
Date:
Subject: Re: jsonb_set() strictness considered harmful to data
Next
From: Thomas Kellerer
Date:
Subject: Re: Composite type storage overhead