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:[EMAIL PROTECTED] 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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to