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

> On Mar 6, 2020, at 11:21, Radics Geza <radicsge@gmail.com> wrote:
>
> I should have written that the precondition is that the column should contains a non-empty json array before the
updateas 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@thebuild.com