Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buys - Mailing list pgsql-general

From Guy Rouillier
Subject Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buys
Date
Msg-id CC1CF380F4D70844B01D45982E671B239E8BEB@mtxexch01.add0.masergy.com
Whole thread Raw
Responses Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buys  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Terry Fielder
Date:
Subject: Re: [pgsql-advocacy] Oracle buys Innobase
Next
From: "Dann Corbit"
Date:
Subject: Re: [pgsql-advocacy] Oracle buys Innobase