Martijn van Oosterhout <kleptog@xxxxxxxxx> writes: > On Fri, Feb 01, 2008 at 11:06:07AM +0100, Nicolas KOWALSKI wrote: >> >> I do not understand why the following ORDER BY statment does not work >> as I would expect: >> >> 3) When I want to sort them, I get this "strange" ordering: > > Show us your collation order: > show lc_collate; Here it is: mon=> show lc_collate; lc_collate ------------- en_US.UTF-8 (1 row) Thanks, -- Nicolas ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster