Nicolas KOWALSKI <niko(at)petole(dot)dyndns(dot)org> writes:
> Martijn van Oosterhout <kleptog(at)svana(dot)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