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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: elein <elein(at)varlena(dot)com>
Cc: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, "news(dot)postgresql(dot)org" <jlim(at)natsoft(dot)com(dot)my>, pgsql-sql(at)postgresql(dot)org
Subject: Re: CHAR(n) always trims trailing spaces in 7.4
Date: 2004-02-18 03:53:17
Message-ID: 20170.1077076397@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

elein <elein(at)varlena(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-02-18 03:54:08 Re: log_line_info plan
Previous Message Bruce Momjian 2004-02-18 03:50:50 Re: [HACKERS] Win32 development question

Browse pgsql-sql by date

  From Date Subject
Next Message David Witham 2004-02-18 04:43:07 Indexes and statistics
Previous Message elein 2004-02-18 00:27:13 Re: CHAR(n) always trims trailing spaces in 7.4