Kris Jurka <books(at)ejurka(dot)com> writes:
> This is a problem with the driver because it is typing the ' ' values as
> text, not char, so the comparison doesn't work right because these two
> types handle trailing spaces differently.
Can you refrain from assigning a type at all? People writing the
equivalent SQL directly would almost always write 'foo', not
'foo'::text or 'foo'::char. The parser's behavior has been tuned
so that that usually works nicely.
regards, tom lane