"Andrus" <[EMAIL PROTECTED]> writes: > I have where clause where all fields are CHAR(10) type and may have trailing > spaces. > ... > Correct result is produced if || operator does not remove trailing spaces.
If you think that trailing spaces are significant data, you should
probably be using VARCHAR not CHAR datatype.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
