On 12/18/2016 2:52 PM, Jong-won Choi wrote:
I have a NULL-able JSONB type column and want to perform upsert, concatenating with the existing value.
NULL does not mean 'NO' value in SQL it means UNKNOWN value. sort of like the 'indeterminate' in math.
maybe you want a NOT NULL json value that you set to '' or something when its empty.
-- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
