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

Sorry you are right it seems one of the triggers caused an issue on my table, then please ignore.
I will check it further.

Thanks a lot for your time!



‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Friday, March 6, 2020 7:24 PM, Christophe Pettus  wrote:

>
>
> > 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 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@thebuild.com