Postgres Pro
Downloads
Home   >   mailing lists

Re: varchar sort ordering ignore blanks - Mailing list pgsql-general

From Tom Lane
Subject Re: varchar sort ordering ignore blanks
Date
Msg-id 26019.1200418648@sss.pgh.pa.us
Whole thread Raw
In response to varchar sort ordering ignore blanks  (Luca Arzeni <l.arzeni@amadego.com>)
Responses Re: varchar sort ordering ignore blanks  ("Luca Arzeni" <l.arzeni@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Segmentation fault with 8.3 FTS ISpell
Next
From: Martijn van Oosterhout
Date:
Subject: Re: bulk copy