Re: Different sort order

[Poul Møller Hansen <freebsd(at)pbnet(dot)dk>]

> What's the output of the following query on each server?
>
> select name, setting from pg_settings where name ~ '^lc_';
>   
Ahh there's a difference
mydb=# select name, setting from pg_settings where name ~ '^lc_';
   name     | setting
-------------+---------
lc_collate  | en_US
lc_ctype    | en_US
lc_messages | en_US
lc_monetary | en_US
lc_numeric  | en_US
lc_time     | en_US

mydb=# select name, setting from pg_settings where name ~ '^lc_';
   name     | setting
-------------+---------
lc_collate  | C
lc_ctype    | C
lc_messages | C
lc_monetary | C
lc_numeric  | C
lc_time     | C

I guess the reason is that PostgreSQL got installed before setting the 
locale,
and the only way to change it is using initdb --locale.

Poul