On Friday, October 17, 2025, Laurenz Albe <[email protected]> wrote:

>
> I suggest the following simplification:
>
> +        <entry><type>text</type>, <type>varchar</type>,
> <type>bpchar</type></entry>
>
>
Calling bpchar an alias of text/varchar does not improve matters.  Sure,
the type itself doesn’t actually care about trailing spaces, but in
practice operations on bpchar values do not behave the same as those on
text values.

select '123  '::bpchar = '123        '::bpchar; // true

David J.

Reply via email to