From: | "Guy Rouillier" <guyr(at)masergy(dot)com> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buys |
Date: | 2005-10-19 20:32:13 |
Message-ID: | CC1CF380F4D70844B01D45982E671B239E8BEB@mtxexch01.add0.masergy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Tino Wildenhain wrote:
>>>>
>>>> Then we are broken too :)
>>>>
>>>> # select 'a ' = 'a ';
>>>> ?column?
>>>> ----------
>>>> f
>>>> (1 row)
>
>
> experiment=# SELECT 'a '::char = 'a '::char;
> ?column?
> ----------
> t
>
This does't show anything useful, because the ::char casting simply
takes the first char of any string:
select 'abc'::char = 'axy'::char
Also results in 'true'. Hopefully no one in this discussion would want
those two strings to be equal.
--
Guy Rouillier
From | Date | Subject | |
---|---|---|---|
Next Message | Dann Corbit | 2005-10-19 20:34:11 | Re: [pgsql-advocacy] Oracle buys Innobase |
Previous Message | Chris Matheson | 2005-10-19 20:22:29 | difficulty formating interval datatypes in 7.4 |
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2005-10-19 20:49:43 | Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buys |
Previous Message | Dann Corbit | 2005-10-19 20:16:23 | Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buysInnobase) |