Re: [NOVICE] jsonb and null - Mailing list pgsql-novice

From Alexey Luchko
Subject Re: [NOVICE] jsonb and null
Date
Msg-id CAF56u8pBS1XNRmbnGE5Oiqz_hb9aY38ykvCPd3Xpt3JfRwycrQ@mail.gmail.com
Whole thread Raw
In response to [NOVICE] jsonb and null  (Alexey Luchko <soulne4ny@gmail.com>)
List 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


pgsql-novice by date:

Previous
From: Alexey Luchko
Date:
Subject: [NOVICE] jsonb and null
Next
From: Stephen Froehlich
Date:
Subject: [NOVICE] Adding SSD to HDD-based System