Re: [pgsql-advocacy] Oracle buys Innobase

On Wed, 19 Oct 2005, Dann Corbit wrote:

> Yes, clearly that is the wrong result according to the SQL standard.
>
> Here is a SQL*Server query:
> select 1 where 'a' = 'a ' AND 'a' = 'a  ' AND 'a ' = 'a         '
>
> It returns (correctly): 1

Doesn't that depend on the collating sequence in use, or is a NO PAD
collating sequence not allowed here?