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