Message-ID: <6e0741dec0f56692dece5a961533c43f3594d0f0.camel@j-davis.com>
Subject: Re: BPCHAR description in 8.3. Character Types is misleading and
 incomplete
From: Jeff Davis <pgsql@j-davis.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>, Sergei Katkovsky
	 <skatkovsky@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, "pgsql-docs@lists.postgresql.org"
	 <pgsql-docs@lists.postgresql.org>
Date: Thu, 16 Oct 2025 08:21:16 -0700
In-Reply-To: 
 <CAKFQuwZJhDgg_WqWq7HMAUd7bGiU4r-VFVXn72Hfq9VQhRKZMw@mail.gmail.com>
References: <176044409338.770.16064383081308443747@wrigleys.postgresql.org>
	 <e9ad2cb03195402a96e8cb9130470bfca3bf49c7.camel@j-davis.com>
	 <1307875.1760556576@sss.pgh.pa.us>
	 <CAAf8JyJNWf9BrpBJNpqEwTM7orbR48XenoALAE8icA68kaC5Wg@mail.gmail.com>
	 <CAKFQuwZJhDgg_WqWq7HMAUd7bGiU4r-VFVXn72Hfq9VQhRKZMw@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.3-0ubuntu1 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/6e0741dec0f56692dece5a961533c43f3594d0f0.camel%40j-davis.com>
Precedence: bulk

On Thu, 2025-10-16 at 08:36 -0400, David G. Johnston wrote:
> A given value has a finite length and there is just no restriction on
> what that length is.=C2=A0 All trailing spaces in the input are considere=
d
> padding for purposes of comparison i.e., manually padding is added by
> the user as opposed to the system.

I see -- so it means that the padding came from somewhere else (not the
type).

> I would leave the note of blank-padded for both and just point out
> the automatic vs manual distinction.

Yeah, it's a table, so if a user is confused, they can read the text
below it. I'm fine with that.

If you think the text below should be improved, do you have a wording
suggestion?

Regards,
	Jeff Davis