Re: Different sort order

> 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