Re: Document NULL

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Document NULL
Дата
Msg-id CAKFQuwaYXxsJg0zLoOQ45bLzSybEbdHXHTDkJkKuQW7bH-HBSA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Document NULL  (Marcos Pegoraro <marcos@f10.com.br>)
Список 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 по дате отправления: