Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange results of ORDER BY clause when item begins - Mailing list pgsql-general

From Ragnar Hafstað
Subject Re: Strange results of ORDER BY clause when item begins
Date
Msg-id 1106170615.22416.6.camel@localhost.localdomain
Whole thread Raw
In response to Strange results of ORDER BY clause when item begins with slash or backslash  (SCassidy@overlandstorage.com)
List pgsql-general
Tree view 
On Wed, 2005-01-19 at 11:24 -0800, SCassidy@overlandstorage.com wrote:
> [non-word character being ignored by ORDER BY]
...
> testdb1=> show LC_COLLATE;
>  lc_collate
> -------------
>  en_US.UTF-8
> (1 row)

this is a 'feature' of your en_US locale:

bash$ export LC_COLLATE=en_US
bash$ (echo "usra";echo "usrq";echo "/usr/lib")| sort
usra
/usr/lib
usrq
bash$ export LC_COLLATE=C
bash$ (echo "usra";echo "usrq";echo "/usr/lib")| sort
/usr/lib
usra
usrq

maybe you should have run initdb with LC_COLLATE=C

gnari

pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: need an advice on running Database
Next
From: Eric E
Date:
Subject: PL/TCL functions won't run