Postgres Pro
Downloads
Home   >   mailing lists

Re: order by question. - Mailing list pgsql-bugs

From Jose Blanco
Subject Re: order by question.
Date
Msg-id 20070504182822.0FAD69FB684@postgresql.org
Whole thread Raw
In response to Re: order by question.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: order by question.  (Peter Eisentraut <peter_e@gmx.net>)
Re: order by question.  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: order by question.  (Ennio-Sr <nasr.laili@tin.it>)
List pgsql-bugs
Tree view 
This second time I did, see

select author, sort_author from itemsbyauthor where sort_author like 'tan%'
order by 2;


"order by 2"

Or am I not understanding something?

Thanks!

-----Original Message-----
From: pgsql-bugs-owner@postgresql.org
[mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Friday, May 04, 2007 2:24 PM
To: Jose Blanco
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] order by question.

"Jose Blanco" <blancoj@umich.edu> writes:
> I'll try this question again.

The answer is the same as before: you didn't specify an ORDER BY clause,
therefore there is no reason to expect any particular output ordering.
Whatever ordering you might happen to see is an implementation artifact.

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: order by question.
Next
From: Alvaro Herrera
Date:
Subject: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)