Postgres Pro
Downloads
Home   >   mailing lists

Re: Document NULL - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject Re: Document NULL
Date
Msg-id CAB-JLwZHmPSY9sN2wCN-puhK4r+O_E_y93y_SOTg9MUowPV__w@mail.gmail.com
Whole thread Raw
In response to Re: Document NULL  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Document NULL
List pgsql-hackers
Tree view
About JSONB_PATH, you said that "JSON null value is considered equal to other JSON null values", but didn't say anything about IS DISTINCT FROM at jsonb_path level. Wouldn't be good to mention something about it ?

select '{1,2}'::integer[] is distinct from null::integer[]
select jsonb_path_exists('[null]', '$[*] ? (@ == null)')

regards
Marcos

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Windows pg_basebackup unable to create >2GB pg_wal.tar tarballs ("could not close file: Invalid argument" when creating pg_wal.tar of size ~ 2^31 bytes)
Next
From: Sanjay Khatri
Date:
Subject: Re: Windows 2016 server crashed after changes in Postgres 15.8 pgAdmin