Re: Sorting when '*' is the initial character - solved

From: "Berend Tober" <btober(at)seaworthysys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: col(at)mportal(dot)hu, "Russell Smith" <mr-russ(at)pws(dot)com(dot)au>
Subject: Re: Sorting when '*' is the initial character - solved
Date: 2005-02-08 15:14:56
Message-ID: 62419.216.238.112.88.1107875696.squirrel@216.238.112.88
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Tue, 8 Feb 2005 01:10 pm, CoL wrote:
>> hi,
>>
>> Berend Tober wrote, On 2/7/2005 22:20:
>> > 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:

--------------
> With 8.0.0 C local, SQL_ASCII Database, I get the expected output.
> Russell Smith
--------------
> order by case when account_id like '*%' then 0 else 1 end
> C.

Thanks. It was pointed out to me that this behavior is normal and is dependent
on the locale setting.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Berend Tober 2005-02-08 15:22:22 Re: Help with sorting (ie. ORDER BY expression)
Previous Message Larry Rosenman 2005-02-08 15:11:21 Re: Creating an index-type for LIKE '%value%'