elein <elein(at)varlena(dot)com> writes:
> This is an example of the problem. It used to expand
> the middle thing to 15.
> elein=# select 'x' || ' '::char(15) || 'x';
> ?column?
> ----------
> xx
> (1 row)
Still does, but then the spaces go away again when the value goes into
the concatenation, because concatenation is a text operator.
regards, tom lane