Re: Document NULL - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Document NULL
Date
Msg-id CAKFQuwY2K1hv6+_sT0vP-GS6jqFw1AeaXya4B4QeZ-az8gfnJQ@mail.gmail.com
Whole thread Raw
In response to Re: Document NULL  (Marcos Pegoraro <marcos@f10.com.br>)
List pgsql-hackers
On Wed, Jun 18, 2025, 11:25 Marcos Pegoraro <marcos@f10.com.br> wrote:
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.

I figured I'd wait for more bike shedding, and maybe other comments, from a committer before going though and doing another mass examples rebuild.  I like my reasoning and it seems easily learned that \N means null on this page's example.  But I'll go with the crowd.

David J.

pgsql-hackers by date:

Previous
From: Marcos Pegoraro
Date:
Subject: Re: Document NULL
Next
From: Tom Lane
Date:
Subject: Re: minimum Meson version