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
