On Tue, 17 Feb 2004, Tom Lane wrote: > 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.
But then this: select 'x'||' '||'x' should produce xx, but it produces x x. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
