Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] [GENERAL] - Mailing list pgsql-hackers

Dann Corbit wrote:
> Try this query in Oracle, SQL*Server, DB/2, Informix, etc.:
>
> connxdatasync=# select 1 where cast('a' as varchar(30)) = cast('a ' as
> varchar(30));
>  ?column?
> ----------
> (0 rows)

For what it's worth, on Sybase ASE I get:


-----------
1
(1 row affected)