Re: CHAR(n) always trims trailing spaces in 7.4 - Mailing list pgsql-sql

From Tom Lane
Subject Re: CHAR(n) always trims trailing spaces in 7.4
Date
Msg-id 20170.1077076397@sss.pgh.pa.us
Whole thread Raw
In response to Re: CHAR(n) always trims trailing spaces in 7.4  (elein <elein@varlena.com>)
Responses Re: CHAR(n) always trims trailing spaces in 7.4
List 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


pgsql-sql by date:

Previous
From: elein
Date:
Subject: Re: CHAR(n) always trims trailing spaces in 7.4
Next
From: "David Witham"
Date:
Subject: Indexes and statistics