"Brian Ceccarelli" <cecca...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs