Re: RES: Order by behaviour - Mailing list pgsql-general

From Stephan Szabo
Subject Re: RES: Order by behaviour
Date
Msg-id 20070329092116.Q23533@megazone.bigpanda.com
Whole thread Raw
In response to RES: Order by behaviour  ("Carlos H. Reimer" <carlos.reimer@opendb.com.br>)
List pgsql-general
On Thu, 29 Mar 2007, Carlos H. Reimer wrote:

> Humm, ok, it is clear now.
>
> And is there a way to change something in this behaviour, like not ignore
> spaces and some type of symbols?

Well, right now it's generally determined by your OS's definition of the
locale you've chosen. You might be able to pick another locale which has
different behavior if your system supports one or gives you a reasonable
way to create one, or as the last ditch attempt, locale "C" for bytewise
ordering. However, I think you'll need to recreate the database if you
change the locale.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Btree indexes, large numbers and <= comparisons
Next
From: "CAJ CAJ"
Date:
Subject: Re: How to speedup CHECKPOINTs?