Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruno Wolff III
Subject Re: Sorting when "*" is the initial character
Date
Msg-id 20050207220450.GA10210@wolff.to
Whole thread Raw
In response to Sorting when "*" is the initial character  ("Berend Tober" <btober@seaworthysys.com>)
List pgsql-general
Tree view 
On Mon, Feb 07, 2005 at 16:20:36 -0500,
  Berend Tober <btober@seaworthysys.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.

pgsql-general by date:

Previous
From: Clodoaldo Pinto
Date:
Subject: Re: Out of memory error
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Out of memory error