Re: Document NULL

On Tue, 18 Jun 2024 20:56:58 -0700
"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Tue, Jun 18, 2024 at 8:34 PM Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp> wrote:
>
> >
> > It may be a trivial thing but I am not sure we need to mention case
> > insensitivity
> > here, because all keywords and unquoted identifiers are case-insensitive in
> > PostgreSQL and it is not specific to NULL.
> >
>
> But it is neither a keyword nor an identifier. It behaves more like:
> SELECT 1 as one; A constant, which have no implied rules - mainly because
> numbers don't have case. Which suggests adding some specific mention there

Thank you for your explanation. This makes a bit clear for me why the description
mentions 'string' syntax there. I just thought NULL is a keyword representing
a null constant.

> - and also probably need to bring up it and its "untyped" nature in the
> syntax chapter, probably here:
>
> https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS-GENERIC
>
>
> > Also, I found the other parts of the documentation use "case-insensitive"
> > in which
> > words are joined with hyphen, so I wonder it is better to use the same
> > form if we
> > leave the description.
> >
> >
> Typo on my part, fixed.
>
> I'm not totally against just letting this content be assumed to be learned
> from elsewhere in the documentation but it also seems reasonable to
> include. I'm going to leave it for now.
>
> David J.

--
Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>