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