Re: Concatenating NULL with JSONB value return NULL

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Concatenating NULL with JSONB value return NULL
Date: 2016-12-18 23:08:24
Message-ID: d752291e-931a-198c-93e6-1b511900208a@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2016-12-18 23:49:40 Re: Concatenating NULL with JSONB value return NULL
Previous Message Jong-won Choi 2016-12-18 22:52:18 Concatenating NULL with JSONB value return NULL