Nicolas KOWALSKI <[EMAIL PROTECTED]> writes:
> Martijn van Oosterhout <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
