Re: jsonb and null

From: Alexey Luchko <soulne4ny(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: jsonb and null
Date: 2017-09-03 17:26:51
Message-ID: CAF56u8pBS1XNRmbnGE5Oiqz_hb9aY38ykvCPd3Xpt3JfRwycrQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> this
>
> SELECT to_jsonb(ARRAY[NULL]::int[])#>'{0}' IS NULL;
>
> is false?

These are surprising as well

> SELECT 'null'::jsonb IS NULL;
?column?
----------
f
(1 row)

> SELECT ('{}'::jsonb)#>'{"a"}' IS NULL;
?column?
----------
t
(1 row)

--
Regards
Alex

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Stephen Froehlich 2017-09-05 16:26:28 Adding SSD to HDD-based System
Previous Message Alexey Luchko 2017-09-03 17:09:15 jsonb and null