Re: [BUGS] Oder by not working

Blanco, Jose wrote:
> Which as you can see is not really the desired behavior. I created a
> test table and loaded these values into a field of type text, and then
> issued the following query:
>
> select * from test order by 1;
> name
> --------
> Ta, A
> Tab, A
> Ta, Z
> (3 rows)

Unlike on some systems, in PostgreSQL "ORDER BY 1" means order by the
constant value "1", not the first column. Try "ORDER BY name".

--
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