jsonb and null

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

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Alexey Luchko 2017-09-03 17:26:51 Re: jsonb and null
Previous Message Dipesh Dangol 2017-09-01 12:36:08 connection breakdown issue in postgresql while using replication slot with the help of stream api java