Horton

Re: CHAR(n) always trims trailing spaces in 7.4

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: elein <elein@varlena.com>
Cc: "scott.marlowe" <scott.marlowe@ihs.com>, "news.postgresql.org" <jlim@natsoft.com.my>, pgsql-sql@postgresql.org
Date: 2004-02-18T03:53:17Z
Lists: pgsql-hackers, pgsql-sql 
elein <elein@varlena.com> writes:
> Apparently the ::char is cast to varchar and then text?

No, directly to text, because the || operator is defined as taking text
inputs.  But there's no practical difference between text and varchar on
this point.

			regards, tom lane