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.
