Is there some way to do ascii-betical sort ordering in postgres (i.e.
capital letters come before lowercase)? It appears that text ordering
is dictionary-alphabetical. It's useful, but it's different from the
DBMS I'm porting some applications from (SQL Server, in case you were
curious).
It may not be terribly important, but it'd be useful to know in case
it actually is an issue.
I couldn't find any clear answer searching online.
Thanks,
Peter