elein <[EMAIL PROTECTED]> writes:
> Somewhere the space trimming occurs.
The cast from char(n) to text (or varchar) is what's doing the trimming
in 7.4. I think you can mostly revert the change by changing that
pg_cast entry to specify no conversion function instead of rtrim().
However that would probably result in squirrely, non-spec behavior for
comparisons.
> If char(n) is properly defined to not trim spaces then
> there should be a separate cat for char(n).
Possibly, but I think that is considering the issue much too narrowly.
Concatenation is not the only textual operator.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
