Postgres Pro
Downloads
Home   >   mailing lists

Re: Sorting when "*" is the initial character - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Sorting when "*" is the initial character
Date
Msg-id 20050207154448.J2309@megazone.bigpanda.com
Whole thread Raw
In response to Sorting when "*" is the initial character  ("Berend Tober" <btober@seaworthysys.com>)
List pgsql-general
Tree view 
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'.

pgsql-general by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: [SECURITY] New sets of PostgreSQL RPMS are available for download
Next
From: Steve Atkins
Date:
Subject: Re: Creating an index-type for LIKE '%value%'