MIME-Version: 1.0
References: <176044409338.770.16064383081308443747@wrigleys.postgresql.org>
 <e9ad2cb03195402a96e8cb9130470bfca3bf49c7.camel@j-davis.com>
In-Reply-To: <e9ad2cb03195402a96e8cb9130470bfca3bf49c7.camel@j-davis.com>
From: Sergei Katkovsky <skatkovsky@gmail.com>
Date: Thu, 16 Oct 2025 10:30:28 +0400
Message-ID: 
 <CAAf8JyLFfbXtP2mjvwHtpXgk4qQMBQfaO91GJTfoy3+PKUga-A@mail.gmail.com>
Subject: Re: BPCHAR description in 8.3. Character Types is misleading and
 incomplete
To: Jeff Davis <pgsql@j-davis.com>
Cc: pgsql-docs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002f4df7064140c2eb"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAf8JyLFfbXtP2mjvwHtpXgk4qQMBQfaO91GJTfoy3%2BPKUga-A%40mail.gmail.com>
Precedence: bulk

--0000000000002f4df7064140c2eb
Content-Type: text/plain; charset="UTF-8"

Hello,

>  I think "blank-insignificant" is slightly better than "blank-ignoring".

Yes, I agree. And there is also "blank-agnostic" if you prefer fancy
expressions :)

>  Please take a look at the attached patch. If you'd like your name
>  included in the commit, please send it as you'd like it to appear.

The patch is correct, in my opinion. Although it would be nice to have
additionally a clear explanation in which contexts blanks in BPCHAR are
insignificant (like in comparison) and in which they are still
meaningful (like in concatenation), that issue could be addressed later
separately, and maybe not even in the docs but rather in wiki.

Regarding my name. I'm new to this list, so I didn't quite understand what
you were asking for exactly. If you just need to know the spelling of my
name, it's Sergei Katkoskii.

With best regards,
Sergei Katkovskii

--0000000000002f4df7064140c2eb
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div di=
r=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">Hello,<br><br>=
&gt;=C2=A0=C2=A0I think &quot;blank-insignificant&quot; is slightly better =
than &quot;blank-ignoring&quot;.<br><br>Yes, I agree. And there is also &qu=
ot;blank-agnostic&quot; if you prefer fancy expressions :)</div><div dir=3D=
"ltr"><br>&gt;=C2=A0 Please take a look at the attached patch. If you&#39;d=
 like your name<br>&gt;=C2=A0 included in the commit, please send it as you=
&#39;d like it to appear.<br><br>The patch is correct,=C2=A0in my opinion. =
Although it=C2=A0would be nice to have additionally a clear=C2=A0explanatio=
n in which contexts blanks in BPCHAR are insignificant=C2=A0(like in compar=
ison) and in which they are still meaningful=C2=A0(like in concatenation), =
that issue could be addressed later separately, and maybe not even in the d=
ocs=C2=A0but rather in wiki.<br><br>Regarding my name. I&#39;m new to this =
list, so I didn&#39;t quite understand what you were asking for exactly. If=
 you just need to know the spelling of my name, it&#39;s Sergei Katkoskii.<=
br><br>With best regards,<br>Sergei Katkovskii</div></div></div></div></div=
></div></div></div>

--0000000000002f4df7064140c2eb--