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

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