Re: Document NULL

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
Cc: 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: 2025-06-18 18:36:04
Message-ID: CAKFQuwY2K1hv6+_sT0vP-GS6jqFw1AeaXya4B4QeZ-az8gfnJQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jun 18, 2025, 11:25 Marcos Pegoraro <marcos(at)f10(dot)com(dot)br> wrote:

> Em ter., 11 de mar. de 2025 às 12:52, David G. Johnston <
>> david(dot)g(dot)johnston(at)gmail(dot)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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2025-06-18 18:36:43 Re: minimum Meson version
Previous Message Paul Jungwirth 2025-06-18 18:25:20 Correct docs about partitions and EXCLUDE constraints