Postgres Pro
Downloads
Home   >   mailing lists

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

From Alexey Luchko
Subject [NOVICE] jsonb and null
Date
Msg-id CAF56u8oihqsnWakT1+qBDvU5f56hitM3_ryLDBUPfbYEqKLa2w@mail.gmail.com
Whole thread Raw
Responses Re: [NOVICE] jsonb and null
List pgsql-novice
Tree view 
Hi!

I've found that jsonb nulls are not SQL NULLs.
I just wonder for what on earth this

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

is false? :)

Regards
Alex

pgsql-novice by date:

Previous
From: Dipesh Dangol
Date:
Subject: [NOVICE] connection breakdown issue in postgresql while using replication slotwith the help of stream api java
Next
From: Alexey Luchko
Date:
Subject: Re: [NOVICE] jsonb and null