| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | "Carlos H(dot) Reimer" <carlos(dot)reimer(at)opendb(dot)com(dot)br> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: RES: Order by behaviour |
| Date: | 2007-03-29 16:24:03 |
| Message-ID: | 20070329092116.Q23533@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | CAJ CAJ | 2007-03-29 16:56:57 | Re: How to speedup CHECKPOINTs? |
| Previous Message | Tom Lane | 2007-03-29 16:01:34 | Re: Btree indexes, large numbers and <= comparisons |