Message-ID: <eec482cfac046c520929157d05d99d6c9694e1ce.camel@cybertec.at>
Subject: Re: BPCHAR description in 8.3. Character Types is misleading and
 incomplete
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Sergei Katkovsky <skatkovsky@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Jeff Davis <pgsql@j-davis.com>,
	pgsql-docs@lists.postgresql.org
Date: Thu, 23 Oct 2025 08:02:21 +0300
In-Reply-To: <96ad1acfb43cc73b0cdbe74719f035b1ee3f77c0.camel@cybertec.at>
References: <176044409338.770.16064383081308443747@wrigleys.postgresql.org>
		 <e9ad2cb03195402a96e8cb9130470bfca3bf49c7.camel@j-davis.com>
		 <1307875.1760556576@sss.pgh.pa.us>
		 <92151c4debb48bbbaed4db81c79d73c36f619858.camel@cybertec.at>
		 <CAAf8JyLJDtbBnx7zc_oPb=16YAHH0PyAh5H_GtZ7R0QJPqthNQ@mail.gmail.com>
		 <ced31f50b2e55502bd2ed739dd48cfc1316ddb35.camel@cybertec.at>
		 <CAAf8JyKpZY+bWLmyP-hR+sQiR0yS+nDTrdqaQbWgrf6uxsXYoQ@mail.gmail.com>
	 <96ad1acfb43cc73b0cdbe74719f035b1ee3f77c0.camel@cybertec.at>
Content-Type: multipart/mixed; boundary="=-v3948VXtSwTCmpY7IANo"
User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/eec482cfac046c520929157d05d99d6c9694e1ce.camel%40cybertec.at>
Precedence: bulk

--=-v3948VXtSwTCmpY7IANo
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, 2025-10-20 at 16:22 +0200, Laurenz Albe wrote:
> > Looks like nobody is against "insignificant/ignorable trailing
> > whitespace" or anything like that anymore? Am I right?
>=20
> Any verbal description will never completely represent the facts.
> But I'd say that "ignores trailing blanks" (not tabs, for example)
> is a fairly accurate description.

Here is a patch along these lines.

Yours,
Laurenz Albe

--=-v3948VXtSwTCmpY7IANo
Content-Disposition: attachment;
	filename="v1-0001-Improve-doc-for-bpchar-without-length-limit.patch"
Content-Transfer-Encoding: base64
Content-Type: text/x-patch;
	name="v1-0001-Improve-doc-for-bpchar-without-length-limit.patch";
	charset="UTF-8"

RnJvbSBlYjcxNjBmNGUyMjc3N2JiOWM3MGY2NjBkYTJmZjRmNzI3OTJjNDk5IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h
dD4KRGF0ZTogVGh1LCAyMyBPY3QgMjAyNSAwODowMDowOCArMDMwMApTdWJqZWN0OiBbUEFUQ0gg
djFdIEltcHJvdmUgZG9jIGZvciBicGNoYXIgd2l0aG91dCBsZW5ndGggbGltaXQKClRoZSBkb2N1
bWVudGF0aW9uIHN0YXRlZCB0aGF0ICJicGNoYXIiIHdhcyAiYmxhbmsgdHJpbW1lZCIsIHdoaWNo
IHNvdW5kcwpsaWtlIGJsYW5rcyBhcmUgcmVtb3ZlZCwgYnV0IHRoZXkgYXJlbid0LiAgUmF0aGVy
LCB0cmFpbGluZyBibGFua3MKZ2V0IGlnbm9yZWQgYnkgbW9zdCBvcGVyYXRpb25zLgoKQXV0aG9y
OiBKZWZmIERhdmlzIDxwZ3NxbEBqLWRhdmlzLmNvbT4KQXV0aG9yOiBMYXVyZW56IEFsYmUgPGxh
dXJlbnouYWxiZUBjeWJlcnRlYy5hdD4KUmVwb3J0ZWQtQnk6IFNlcmdlaSBLYXRrb3Zza3kgPHNr
YXRrb3Zza3lAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzE3NjA0
NDQwOTMzOC43NzAuMTYwNjQzODMwODEzMDg0NDM3NDclNDB3cmlnbGV5cy5wb3N0Z3Jlc3FsLm9y
ZwotLS0KIGRvYy9zcmMvc2dtbC9kYXRhdHlwZS5zZ21sIHwgNCArKy0tCiAxIGZpbGUgY2hhbmdl
ZCwgMiBpbnNlcnRpb25zKCspLCAyIGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMv
c2dtbC9kYXRhdHlwZS5zZ21sIGIvZG9jL3NyYy9zZ21sL2RhdGF0eXBlLnNnbWwKaW5kZXggYjgx
ZDg5ZTI2MDguLmFkN2VlMjI1OTczIDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvZGF0YXR5cGUu
c2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvZGF0YXR5cGUuc2dtbApAQCAtMTE3OCw3ICsxMTc4LDcg
QEAgU0VMRUNUICc1MjA5My44OSc6Om1vbmV5OjpudW1lcmljOjpmbG9hdDg7CiAgICAgICAgPC9y
b3c+CiAgICAgICAgPHJvdz4KICAgICAgICAgPGVudHJ5Pjx0eXBlPmJwY2hhcjwvdHlwZT48L2Vu
dHJ5PgotICAgICAgICA8ZW50cnk+dmFyaWFibGUgdW5saW1pdGVkIGxlbmd0aCwgYmxhbmstdHJp
bW1lZDwvZW50cnk+CisgICAgICAgIDxlbnRyeT52YXJpYWJsZSB1bmxpbWl0ZWQgbGVuZ3RoLCBp
Z25vcmVzIHRyYWlsaW5nIGJsYW5rczwvZW50cnk+CiAgICAgICAgPC9yb3c+CiAgICAgICAgPHJv
dz4KICAgICAgICAgPGVudHJ5Pjx0eXBlPnRleHQ8L3R5cGU+PC9lbnRyeT4KQEAgLTEyOTgsNyAr
MTI5OCw3IEBAIFNFTEVDVCAnNTIwOTMuODknOjptb25leTo6bnVtZXJpYzo6ZmxvYXQ4OwogCiAg
ICA8dGlwPgogICAgIDxwYXJhPgotICAgICBUaGVyZSBpcyBubyBwZXJmb3JtYW5jZSBkaWZmZXJl
bmNlIGFtb25nIHRoZXNlIHRocmVlIHR5cGVzLAorICAgICBUaGVyZSBpcyBubyBwZXJmb3JtYW5j
ZSBkaWZmZXJlbmNlIGFtb25nIHRoZXNlIGZvdXIgdHlwZXMsCiAgICAgIGFwYXJ0IGZyb20gaW5j
cmVhc2VkIHN0b3JhZ2Ugc3BhY2Ugd2hlbiB1c2luZyB0aGUgYmxhbmstcGFkZGVkCiAgICAgIHR5
cGUsIGFuZCBhIGZldyBleHRyYSBDUFUgY3ljbGVzIHRvIGNoZWNrIHRoZSBsZW5ndGggd2hlbiBz
dG9yaW5nIGludG8KICAgICAgYSBsZW5ndGgtY29uc3RyYWluZWQgY29sdW1uLiAgV2hpbGUKLS0g
CjIuNTEuMAoK


--=-v3948VXtSwTCmpY7IANo--