Re: Sorting when "*" is the initial character

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Berend Tober <btober(at)seaworthysys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Sorting when "*" is the initial character
Date: 2005-02-07 23:48:57
Message-ID: 20050207154448.J2309@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 7 Feb 2005, Berend Tober wrote:

> I encountered what looks like unusually sorting behavior, and I'm wondering if
> anyone can tell me if this is supposted to happen (and then if so, why) or if
> this is a bug:

If you ran initdb with a locale such as en_US, a result like what you got
is expected. AFAIR, the collation rules for the locale are defined to not
use symbols and spaces in the first pass comparison so '110' < '*115' <
'120'.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2005-02-08 00:25:10 Re: Creating an index-type for LIKE '%value%'
Previous Message Devrim GUNDUZ 2005-02-07 23:37:37 [SECURITY] New sets of PostgreSQL RPMS are available for download