Re: ascii-betical sort order? - Mailing list pgsql-sql

From Tom Lane
Subject Re: ascii-betical sort order?
Date
Msg-id 10924.1241805448@sss.pgh.pa.us
Whole thread Raw
In response to ascii-betical sort order?  (Peter Koczan <pjkoczan@gmail.com>)
Responses Re: ascii-betical sort order?  (Peter Koczan <pjkoczan@gmail.com>)
List pgsql-sql
Peter Koczan <pjkoczan@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.
        regards, tom lane


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: performance question
Next
From: Peter Koczan
Date:
Subject: Re: ascii-betical sort order?