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 5598.1251253096@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #4999: select 'a' < 'A' is true, but should be false . . .  ("Brian Ceccarelli" <ceccareb@talusmusic.com>)
List pgsql-bugs
"Brian Ceccarelli" <ceccareb@talusmusic.com> writes:
>      After a long and careful study of this, this is a Postgres bug.
> Postgres is boogering up the sort.   The operators < >, and the "order by"
> in the select statement are both case-sensitive and case-insensitive.    It
> is inconsistent.

"Consistency" is not a hallmark of the sort ordering in most non-C
locales :-(.  If this behavior troubles you, use C locale.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Brian Ceccarelli"
Date:
Subject: Re: BUG #4999: select 'a' < 'A' is true, but should be false . . .
Next
From: Jaime Casanova
Date:
Subject: Re: BUG #4999: select 'a' < 'A' is true, but should be false . . .