Re: CHAR(n) always trims trailing spaces in 7.4
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: elein <elein@varlena.com>
Cc: "news.postgresql.org" <jlim@natsoft.com.my>, pgsql-sql@postgresql.org
Date: 2004-02-17T23:40:49Z
Lists: pgsql-hackers, pgsql-sql
elein <elein@varlena.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