Re: varchar sort ordering ignore blanks

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Luca Arzeni <l(dot)arzeni(at)amadego(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: varchar sort ordering ignore blanks
Date: 2008-01-15 17:37:28
Message-ID: 26019.1200418648@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Luca Arzeni <l(dot)arzeni(at)amadego(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-01-15 17:43:05 Re: bulk copy
Previous Message Tom Lane 2008-01-15 17:30:17 Re: Segmentation fault with 8.3 FTS ISpell