Re: Document NULL

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>, 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:24:25
Message-ID: CAB-JLwbrGFFo9J+1cDibayX8NuVe-5u0nwL1gnRy7Oz2J0EzWw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> 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.

regards
Marcos

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Devrim Gündüz 2025-06-18 18:25:15 Re: minimum Meson version
Previous Message Devrim Gündüz 2025-06-18 18:23:12 Re: minimum Meson version