| 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: | Álvaro Herrera <alvherre(at)kurilemu(dot)de>, jian he <jian(dot)universality(at)gmail(dot)com>, Jeff Davis <pgsql(at)j-davis(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: | 2026-01-29 19:29:32 |
| Message-ID: | CAB-JLwbJz06-H-F2nYBKsGaqNB9aDhT4on-Anhw40Tq-9YoTGg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Em qua., 28 de jan. de 2026 às 20:34, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> escreveu:
> Notably, I went with "Null" as the \pset display null value instead of \N
> (find-replace and fixes, did not re-run commands in psql, looks correct
> though and it is fairly mechanical).
>
It seems you didn't correctly replace \N with Null.
All nulls inside an array should be uppercase, all are fine.
Json nulls should be lowercase, all are fine
But some nulls of these results have a "null" instead of "Null"
+ country | flagship
+ id | value | IS NULL | IS DIST | IS !=
+ c | c IS N | NOT c IS N | c IS NOT N | ROW(v,v) IS N | ROW(v,v) IS
NOT N
+ In Present | In Missing | N In Non-N | N In N
+ id | value | Affirm | Negate | Safe Affirm | Safe Negate
+ id | value | de_id | de_value | pg_typeof
+ id | IS NULL
Additionally, some column aliases you used NULL, some N and some Null,
wouldn't it be better to standardize them ?
If you agree, would you use uppercase ? I can change them if you want,
there are a lot of them.
regards
Marcos
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Antonin Houska | 2026-01-29 19:52:47 | Re: Race conditions in logical decoding |
| Previous Message | Andres Freund | 2026-01-29 19:29:27 | Re: Buffer locking is special (hints, checksums, AIO writes) |