Luca Arzeni <l.arzeni@xxxxxxxxxxx> writes:
> That is: the sort order in postgres 8.1.9 seems to ignore the blank.
This is expected behavior in most non-C locales.
> In all cases I'm using locale LATIN9 during DB creation, but I tested also
> with ASCII, UTF8 and LATIN1 encoding.
LATIN9 isn't a locale, it's an encoding. Try "initdb --locale=C".
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
