> 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