On Fri, Oct 29, 2021 at 3:09 PM Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>
wrote:
> and those functions that do directly take a bpchar type for comparison
> purposes trigger the "semantically insignificant and disregarded" bit. For
> practical purposes you will frequently hit the one bit or the other.
>
>
As I noted in a prior reply, octet_length(char) does the length computation
with the padding spaces. So it is possible for char input functions to do
the expected thing.
David J.