Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4999: select 'a' < 'A' is true, but should be false . . . - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4999: select 'a' < 'A' is true, but should be false . . .
Date
Msg-id 20806.1250808010@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4999: select 'a' < 'A' is true, but should be false . . .  ("Brian Ceccarelli" <ceccareb@talussoftware.com>)
List pgsql-bugs
Tree view 
"Brian Ceccarelli" <ceccareb@talussoftware.com> writes:
> since the < and > comparison operators seem to be case insensitive:

They are not, unless you have managed to find a case-insensitive locale
somewhere.  In any case we would not think that 'a' = 'A'.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Greg Stark
Date:
Subject: Re: BUG #5000: Optimizer does not use function-based index for an order by
Next
From: "Hiroshi Saito"
Date:
Subject: Re: BUG #4991: problem with ODBC driver 8.4