X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 21458D1D1CD
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 18 Feb 2004 03:53:44 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 63867-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Feb 2004 23:53:45 -0400 (AST)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by svr1.postgresql.org (Postfix) with ESMTP id 321B0D1D16D
	for <pgsql-sql@postgresql.org>; Tue, 17 Feb 2004 23:53:40 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1I3rHW2020171;
	Tue, 17 Feb 2004 22:53:17 -0500 (EST)
To: elein <elein@varlena.com>
Cc: "scott.marlowe" <scott.marlowe@ihs.com>,
	"news.postgresql.org" <jlim@natsoft.com.my>, pgsql-sql@postgresql.org
Subject: Re: CHAR(n) always trims trailing spaces in 7.4 
In-reply-to: <20040217162713.H25537@cookie.varlena.com> 
References: <18872.1077061249@sss.pgh.pa.us>
	<Pine.LNX.4.33.0402171706530.31955-100000@css120.ihs.com>
	<20040217162713.H25537@cookie.varlena.com>
Comments: In-reply-to elein <elein@varlena.com>
	message dated "Tue, 17 Feb 2004 16:27:13 -0800"
Date: Tue, 17 Feb 2004 22:53:17 -0500
Message-ID: <20170.1077076397@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/239
X-Sequence-Number: 16929

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