Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Concatenating NULL with JSONB value return NULL - Mailing list pgsql-general

From John R Pierce
Subject Re: [GENERAL] Concatenating NULL with JSONB value return NULL
Date
Msg-id d752291e-931a-198c-93e6-1b511900208a@hogranch.com
Whole thread Raw
In response to [GENERAL] Concatenating NULL with JSONB value return NULL  (Jong-won Choi <jongwon@ticketsquad.com>)
Responses Re: [GENERAL] Concatenating NULL with JSONB value return NULL  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jong-won Choi
Date:
Subject: [GENERAL] Concatenating NULL with JSONB value return NULL
Next
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] Concatenating NULL with JSONB value return NULL