From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | Andrei Bintintan <klodoma(at)ar-sd(dot)net> |
Cc: | "[ADMIN]" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Sensitive sort problem? |
Date: | 2003-11-25 17:53:33 |
Message-ID: | 20031125095150.J20420@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Tue, 25 Nov 2003, Andrei Bintintan wrote:
> I give an example:
>
> These are the datas from the table names:
>
> id n1 n2
> 1 AaAa AaAa
> 2 X X
> 3 A A
> 4 a a
> 5 ab ab
> 6 _Y _Y
> 8 ..a ..a
> 9 .x .x
> 7 ...a ...a
>
> If I run: select * from names order by n1: the result is:
>
> id n1 n2
> 4 a a
> 8 ..a ..a
> 7 ...a ...a
> 3 A A
> 1 AaAa AaAa
> 5 ab ab
> 9 .x .x
> 2 X X
> 6 _Y _Y
>
> Which I don't think that is right. I don't know what happened. But I
> find that the ASCII char order is not respected here.
As Tom said, you've probably run initdb in a locale other than "C".
For example, I believe the above is correct for en_US.
From | Date | Subject | |
---|---|---|---|
Next Message | Grzegorz Dostatni | 2003-11-25 22:21:45 | Size on Disk |
Previous Message | Donald Fraser | 2003-11-25 17:52:26 | Re: Sensitive sort problem? |