On Friday, October 17, 2025, Laurenz Albe <
laurenz.albe@cybertec.at> 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.