Bryan White <nickt...@gmail.com> writes: > I was suprised to find out that ORDER BY is case insensitive. Is > there a way to do a case sensitive ORDER BY clause?
Text sort order is determined by the rules of the locale you're using, specifically the database's LC_COLLATE setting. Most implementations of en_US locale use "dictionary" ordering. You might prefer C locale's rules instead. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql