Re: Sorting when "*" is the initial character

From: Bruno Wolff III <bruno(at)wolff(dot)to>
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 22:04:50
Message-ID: 20050207220450.GA10210@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 07, 2005 at 16:20:36 -0500,
Berend Tober <btober(at)seaworthysys(dot)com> wrote:
>
> SELECT * FROM sample_table ORDER BY 1;
>
> account_id,account_name
> 100,First account
> 110,Second account
> *115,Fifth account
> 120,Third account
> *125,Fourth account
>
> I would expect to see
>
> account_id,account_name
> *115,Fifth account
> *125,Fourth account
> 100,First account
> 110,Second account
> 120,Third account

This depends on your locale.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Clodoaldo Pinto 2005-02-07 22:05:23 Re: Out of memory error
Previous Message Joshua D. Drake 2005-02-07 22:02:54 PHP/PDO Database Abstraction Layer