On Fri, Mar 6, 2020 at 1:52 PM Radics Geza <radicsge(at)gmail(dot)com> wrote:
> Json column is not updated if the update is an empty array '[]'.
>
> UPDATE table SET "jsonbcol" = '[{"a":1}]';
> UPDATE table SET "jsonbcol = '[]' RETURNING "jsonbcol";
>
> jsonbcol
> ------------
> [{"a": 1}]
> (1 row)
>
> It worked in postgres 9.6, but not in 11.7 / 12.2
>
Works for me. Please show a complete working example, with CREATE TABLE,
INSER, and an UPDATE statement with legal table name and with balanced
quotes.
Cheers,
Jeff