Nicolas KOWALSKI <niko@xxxxxxxxxxxxxxxxx> writes: > Martijn van Oosterhout <kleptog@xxxxxxxxx> 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
