Scott Royston <scroyston@mac.com> writes:
> [ various examples of comparing char and varchar ]
I see no bug here. For the CHAR datatype, trailing spaces are defined
to be insignificant. For VARCHAR and TEXT, trailing spaces are
significant. If you want to compare a CHAR value to a VARCHAR or TEXT
value, your best bet is a locution likertrim(charval) = varcharval
regards, tom lane