Re: Document NULL

Marcos Pegoraro <marcos@f10.com.br>

From: Marcos Pegoraro <marcos@f10.com.br>

To: "David G. Johnston" <david.g.johnston@gmail.com>

Cc: jian he <jian.universality@gmail.com>, Jeff Davis <pgsql@j-davis.com>, Yugo NAGATA <nagata@sraoss.co.jp>, Tom Lane <tgl@sss.pgh.pa.us>, Peter Eisentraut <peter@eisentraut.org>, David Rowley <dgrowleyml@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-06-18T18:24:25Z

Lists: pgsql-hackers

>
> Em ter., 11 de mar. de 2025 às 12:52, David G. Johnston <
> david.g.johnston@gmail.com> escreveu:
>
I'm mostly indifferent and it is very simple to change.  It seemed
> desirable to have the main topic of this page display as something that
> isn't invisible though.  And NULL was unappealing since it naturally
> appears in data.  Since COPY uses \N I figured it was a decent choice.
> <null> or <NULL> came to mind too, but there were long compared to 1, 2,
> and 4 that appear along side it.
>

You decided to show \N for Nulls. I think that the user who has questions
about nulls is usually a newbie, so he also doesn't know the COPY format
for nulls. And even GUIs, which are often used for learning, display a word
for nulls, be it NULL, <null>, [null] or something similar.

regards
Marcos