Re: BUG #4999: select 'a' < 'A' is true, but should be false . . .

"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