Re: JSON array is not updated if updating with empty array

> On Mar 6, 2020, at 11:21, Radics Geza <radicsge(at)gmail(dot)com> wrote:
>
> I should have written that the precondition is that the column should contains a non-empty json array before the update as in the example.
> (The insert works, the update also works if the previous content was not an array before e.g. null or '{}' but not as above)

I'm still not able to reproduce it on 11.7:

xof=# create table t (j jsonb);
CREATE TABLE
xof=# insert into t values('[{"b": 1}]');
INSERT 0 1
xof=# update t set j = '[{"a": 1}]';
UPDATE 1
xof=# table t;
j
------------
[{"a": 1}]
(1 row)

xof=# update t set j = '[]';
UPDATE 1
xof=# table t;
j
----
[]
(1 row)

--
-- Christophe Pettus
xof(at)thebuild(dot)com