Re: problem with ORDER BY - Mailing list pgsql-general

Nicolas KOWALSKI <niko@petole.dyndns.org> writes:
> Martijn van Oosterhout <kleptog@svana.org> writes:
>> Show us your collation order:
>> show lc_collate;

> Here it is:

> mon=> show lc_collate;
>  lc_collate
> -------------
>  en_US.UTF-8
> (1 row)

The ordering you showed is correct according to en_US (and most other
non-C locales).  The ordering you want is used in "C" locale.
Unfortunately you have to re-initdb to change the locale of a
database :-(
    initdb --locale=C

            regards, tom lane