| From: | Marcos Pegoraro <marcos(at)f10(dot)com(dot)br> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | jian he <jian(dot)universality(at)gmail(dot)com>, Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter(at)eisentraut(dot)org>, David Rowley <dgrowleyml(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Document NULL |
| Date: | 2024-11-21 13:49:52 |
| Message-ID: | CAB-JLwZHmPSY9sN2wCN-puhK4r+O_E_y93y_SOTg9MUowPV__w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sanjay Khatri | 2024-11-21 13:50:23 | Re: Windows 2016 server crashed after changes in Postgres 15.8 pgAdmin |
| Previous Message | Thomas Munro | 2024-11-21 13:38:09 | 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) |