| 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
| 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 |
| 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 |