Re: Document NULL - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Document NULL
Date
Msg-id CAKFQuwaYXxsJg0zLoOQ45bLzSybEbdHXHTDkJkKuQW7bH-HBSA@mail.gmail.com
Whole thread Raw
In response to Re: Document NULL  (Marcos Pegoraro <marcos@f10.com.br>)
List pgsql-hackers
On Sat, Nov 23, 2024 at 5:30 AM Marcos Pegoraro <marcos@f10.com.br> wrote:
Em qui., 21 de nov. de 2024 às 12:04, David G. Johnston <david.g.johnston@gmail.com> escreveu:

Typo in NuLl, mixed upper and lower case.

SELECT
    NULL AS "Literal Null Value",
    pg_typeof(null) AS "Type of Null",
    pg_typeof(NuLl::text) AS "Type of Cast null",
    cast(null as text) AS "Cast null value";

should be 
    pg_typeof(null::text) AS "Type of Cast Null",

That was not a typo.  I'm intentionally showing an example demonstrating that the SQL NULL is fully case-insensitive.  But I suppose showing both all-upper and all-lower cases fulfills that goal sufficiently.  Changed.  Went with NULL so there are two of each.  Made all of the column headers Title Case.

Thanks!

David J.

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: meson missing test dependencies
Next
From: "David G. Johnston"
Date:
Subject: Re: Document NULL