Tom Lane <tgl@xxxxxxxxxxxxx> writes: > 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 Thanks Tom, using the C locale as indicated gets this right in our database. Best regards, -- Nicolas ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq