Scott Royston <[EMAIL PROTECTED]> 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 like rtrim(charval) = varcharval regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly