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
Peter Koczan pjkoc...@gmail.com writes:
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.
You're apparently using a non-C locale ... you need to re-initdb in
C locale.
On Fri, May 8, 2009 at 12:57 PM, Tom Lane t...@sss.pgh.pa.us wrote:
You're apparently using a non-C locale ... you need to re-initdb in
C locale.
On Fri, May 8, 2009 at 12:58 PM, Kenneth Marshall k...@rice.edu wrote:
Try looking under Localization in the manual (Chapter 22).
Excellent, just