Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vlfBi-001w3u-1a for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Jan 2026 03:28:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vlfBg-002VKt-1i for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Jan 2026 03:28:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vlfBg-002VKl-0k for pgsql-hackers@lists.postgresql.org; Fri, 30 Jan 2026 03:28:49 +0000 Received: from mail-dy1-x1342.google.com ([2607:f8b0:4864:20::1342]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vlfBb-0005fr-1b for pgsql-hackers@lists.postgresql.org; Fri, 30 Jan 2026 03:28:47 +0000 Received: by mail-dy1-x1342.google.com with SMTP id 5a478bee46e88-2b4520f6b32so3445866eec.0 for ; Thu, 29 Jan 2026 19:28:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1769743722; x=1770348522; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=JjIxmhC7VHHR0MdNFu+IzNzRbqwAHxG5yuaENMQfldg=; b=MnPBf0RXFcyxKaiRkl6MsBlx1Lnk81XmB6iTRRCsmO3R4ZOjdSElt4Biwo8xY02RJk xaHpTeYfFFR6rpdheR5kCjdDqJbnhZor8pu44rDZ+2KY10JOTm9rbQ9WK13MISj3s4bw sxAPj+ckxXu2TC3/7jHn8MK9jNEHOFDMArZ+vyb/pnhhYZjY+pS1iELIMEAxgrWlaTyR kRVmoh64yuo8tY9Ro7RPUlM/Xfsonl/YX5mPuhbfdnQvweJ22WaPsdczKDrycWgUZcBs TVi+Z0yh5wNJgU063zkdedjybT0Mk6zH5afgHSwkPzQ9czR30LE6NGxMHVrPIJiJ7qcH mZdA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769743722; x=1770348522; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-gg:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=JjIxmhC7VHHR0MdNFu+IzNzRbqwAHxG5yuaENMQfldg=; b=kZ/vNfBY49yzEEDfCj1Sxs0/edqK5IklFjZM2/iYkuKUPHP7JCLG2RYaZrkviP5cXi ZZPS1KIpXMiEq7xrFj5ZHEpr1d4g+svnGBRkL+VXPRvTCoojj+4jh2uU97U3NPc/HAZe hCh/XQBc4bg6zxDpYEmQOTEDlskOvhEjd6x+XQCDRosbI0HnpVZuS0XTu8n13AygNL2Y YHKjyE7q86SIAnSPSLbz+L6rvimxN0FMoFMWWyUz7AAbct+41D73XK3RR1qdaz76u/ny yOYtaJEEOY48ZhXZIEAKmdBmpDOiYimKph5uFzw+oYGFpToav6ZVUqChgATXkLDx7bIR jhnA== X-Forwarded-Encrypted: i=1; AJvYcCUQXI1lhWa7wpXFKiR/2Lb83xRygNu70ysoFFWKIAZXTvOo3SSCGx1SKONCvjJsaeBbkjzEiqBY4SVBpmo1@lists.postgresql.org X-Gm-Message-State: AOJu0YwFjK7mbIlty1Y6R2vw4bidmpEZLxyoLi5DShZi9mNj+mZY+1Zq NG8qtwIyZmE5lSJjuX5f52W+Lxvv73oiWGj0FUGJxLrJaTaqfcuDP3j4 X-Gm-Gg: AZuq6aL25idmQQFQ/sEhDLNybfh0sKhBBsVAxxPKKGgma3C87j8LpCBwQx2rWSNWNG6 oZUW7ACl+zKCg92KI7utuC/xW4MLw9ko8U7f4al8JHFPUpI1inrmqxQkwcXf3uhWDL1BoNdatvp LAdMICR0TD9sPDLjLrUdOHrZRGxWQIMN41efrCVR696hj+sZRG4v6lCqbgvoDAMhreaPCaZlQP7 vn39Yk2VvpxOXI7unb9SzVggIEtgGC+oFuuWpN4IJXGIjvpybK6OAAkSs9FoRDEctGGIVCPuBep GYulnXXmffetnEAyIwE2C1zcb9+9U2DxOThFUDhNp87TVDj4IKu8h21ir0A7MrJMWoEN1DqESEq HkGWLcHfNPy0WlpYOzIbClStYXTaUBWzjfHoZwcgqNjRXyYcSr4lqbbGA1/DLhK44RqCaxl+pRQ xhsxmRmbX7n4Vmmy3eGquDQtV0yCwdn7I= X-Received: by 2002:a05:7301:2f95:b0:2b0:4b5b:6820 with SMTP id 5a478bee46e88-2b7c88da4f1mr790238eec.26.1769743722379; Thu, 29 Jan 2026 19:28:42 -0800 (PST) Received: from smtpclient.apple ([142.171.105.12]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-2b7a16eab72sm9286103eec.8.2026.01.29.19.28.39 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 29 Jan 2026 19:28:41 -0800 (PST) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.300.41.1.7\)) Subject: Re: Document NULL From: Chao Li In-Reply-To: Date: Fri, 30 Jan 2026 11:27:59 +0800 Cc: Marcos Pegoraro , =?utf-8?Q?=C3=81lvaro_Herrera?= , jian he , Jeff Davis , Yugo NAGATA , Tom Lane , Peter Eisentraut , David Rowley , PostgreSQL Hackers Content-Transfer-Encoding: quoted-printable Message-Id: <1DCE7273-CC25-4179-B603-C52C3F906FA5@gmail.com> References: <202511111530.xp4avso6b4pb@alvherre.pgsql> To: "David G. Johnston" X-Mailer: Apple Mail (2.3864.300.41.1.7) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Jan 30, 2026, at 10:16, David G. Johnston = wrote: >=20 > On Thu, Jan 29, 2026 at 2:18=E2=80=AFPM David G. Johnston = wrote: > Thank you for the review. My bad on these. I'm working through all = the examples again to get them cleaned up properly. >=20 > v11 with the examples work as a separate patch over v10 to be = squashed. >=20 > Tried to be consistent on "Title Case" within headers other than a few = where the all-caps operator really made the most sense. > Got NULL for SQL null literals throughout and Null for psql display of = the same. > Removed abbreviations in titles generally. Re-worked a couple of the = more complex ones. >=20 > Decided to leave my agent instructions in place (xml-styled comment). = The flow actually worked pretty well, though it's nuanced enough to be = wary of false-negatives. Hopefully I got them all. >=20 > David J. >=20 > = I failed to build v11: ``` chaol@ChaodeMacBook-Air sgml % make html /usr/bin/xmllint --nonet --path . --path . --output postgres-full.xml = --noent --valid postgres.sgml nullvalues.sgml:735: parser error : StartTag: invalid element name s | t | Stored =3D Stored | Stored < Constructor | Stored =3D = Constructor ^ nullvalues.sgml:1206: parser error : chunk is not well balanced ^ ddl.sgml:171: parser error : Entity 'nullvalues' failed to parse &nullvalues; ^ ddl.sgml:5871: parser error : chunk is not well balanced ^ postgres.sgml:105: parser error : Entity 'ddl' failed to parse &ddl; ^ make: *** [postgres-full.xml] Error 1 ``` Best regards, -- Chao Li (Evan) HighGo Software Co., Ltd. https://www.highgo.com/