Re: Oder by not working - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: Oder by not working
Date
Msg-id 489BE238.5030405@enterprisedb.com
Whole thread Raw
In response to Re: Oder by not working  ("Blanco, Jose" <blancoj@umich.edu>)
List pgsql-bugs
As Tom pointed out, the order depends on the locale.

Blanco, Jose wrote:
> So is there no way to make oder by work with names?
>
> -----Original Message-----
> From: Heikki Linnakangas [mailto:heikki@enterprisedb.com]
> Sent: Thursday, August 07, 2008 3:00 AM
> To: Blanco, Jose
> Cc: pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] Oder by not working
>
> Heikki Linnakangas wrote:
>> Unlike on some systems, in PostgreSQL "ORDER BY 1" means order by the
>> constant value "1", not the first column. Try "ORDER BY name".
>
> Oh, that's of course not correct at all. "ORDER BY 1" does indeed mean
> order by first column. I don't know what I was thinking,
>


--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-bugs by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Hmm, nodeUnique doesn't really support backwards scan too well
Next
From: "Ismael Ciordia, Openbravo"
Date:
Subject: Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows