Re: BPCHAR description in 8.3. Character Types is misleading and incomplete

From: Sergei Katkovsky <skatkovsky(at)gmail(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: BPCHAR description in 8.3. Character Types is misleading and incomplete
Date: 2025-10-16 06:30:28
Message-ID: CAAf8JyLFfbXtP2mjvwHtpXgk4qQMBQfaO91GJTfoy3+PKUga-A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Sergei Katkovsky 2025-10-16 06:53:59 Re: BPCHAR description in 8.3. Character Types is misleading and incomplete
Previous Message Jeff Davis 2025-10-15 20:09:54 Re: BPCHAR description in 8.3. Character Types is misleading and incomplete