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