Re: varchar sort ordering ignore blanks

Luca Arzeni <l.arzeni@amadego.com> 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