Re: ascii-betical sort order?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Koczan <pjkoczan(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: ascii-betical sort order?
Date: 2009-05-08 17:57:28
Message-ID: 10924.1241805448@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Peter Koczan <pjkoczan(at)gmail(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Koczan 2009-05-08 19:08:56 Re: ascii-betical sort order?
Previous Message Tom Lane 2009-05-08 17:55:36 Re: performance question