"Brian Ceccarelli" <ceccareb(at)talusmusic(dot)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