Re: How to concat strings so that trailing spaces remain

"Andrus" <eetasoft@online.ee> 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