elein <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org