Bryan White <nicktook(at)gmail(dot)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