Re: Document NULL - Mailing list pgsql-hackers

From Yugo NAGATA
Subject Re: Document NULL
Date
Msg-id 20240619141520.9fefb69d051fb112f41bf1d1@sraoss.co.jp
Whole thread Raw
In response to Re: Document NULL  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Document NULL
List pgsql-hackers
On Tue, 18 Jun 2024 20:56:58 -0700
"David G. Johnston" <david.g.johnston@gmail.com> wrote:

> On Tue, Jun 18, 2024 at 8:34 PM Yugo NAGATA <nagata@sraoss.co.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@sraoss.co.jp>



pgsql-hackers by date:

Previous
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: 001_rep_changes.pl fails due to publisher stuck on shutdown
Next
From: Amit Kapila
Date:
Subject: Re: Allow logical failover slots to wait on synchronous replication