Re: Document NULL

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, 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: 2026-01-06 19:11:11
Message-ID: CAB-JLwbjzGL-Jtb-AuTrgBkVWKH8LUXDu3wxkLyOLHXUH4UYmg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Em ter., 11 de nov. de 2025 às 12:34, Álvaro Herrera <alvherre(at)kurilemu(dot)de>
escreveu:

> I have rebased this; here's v9. I haven't reviewed it in depth, but
> intend to give it a read and get it pushed sometime in the
> not-too-distant future, so if anybody wants to review it some more, it'd
> be appreciated.
>

- Reading this document I see that he uses "the empty string" but DOCs uses
more "an empty string".
Then a few minutes ago I sent a patch [1] to use "an empty string" instead
of "the empty string".
If that patch is accepted then this could be done here too.
- I think using several commands and their results in a <programlisting> is
difficult to read,
mainly because some commands result on 2 or more lines, some an empty line,
so it is difficult to see what command generated what result. Maybe
separate them into 2 blocks, maybe.

<programlisting>
-- The transaction markers are left here to emphasize the rollback behavior.
SHOW example.string;
BEGIN;
SELECT set_config('example.string', NULL, true);
SELECT current_setting('example.string') IS NULL AS "Setting Is Null";
ROLLBACK;
SHOW example.string;
RESET example.string;
SHOW example.string;
</programlisting>

1 -
https://www.postgresql.org/message-id/CAB-JLwa2AgHWqz1Lf2ev2pb71yqbM0yBg-jwN0xnDn88BWystg%40mail.gmail.com

regards
Marcos

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Eric Ridge 2026-01-06 19:25:07 Re: pg18 bug? SELECT query doesn't work
Previous Message Jelte Fennema-Nio 2026-01-06 19:07:22 Re: RFC: adding pytest as a supported test framework