Re: Oder by not working

From: "Blanco, Jose" <blancoj(at)umich(dot)edu>
To: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Oder by not working
Date: 2008-08-07 14:21:19
Message-ID: E0217C87D1BA1043AC897ACFA468CEE60120BA47@ECLUST2-VS3.adsroot.itcs.umich.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

So is there no way to make oder by work with names?

-----Original Message-----
From: Heikki Linnakangas [mailto:heikki(at)enterprisedb(dot)com]
Sent: Thursday, August 07, 2008 3:00 AM
To: Blanco, Jose
Cc: pgsql-bugs(at)postgresql(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-08-07 14:42:27 Re: BUG #4345: ERROR: OUT OF MEMORY
Previous Message valgog 2008-08-07 12:37:32 Re: BUG #4343: upper, lower, initcap do not work with umlaute? (important!)