Re: order by question.

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(at)postgresql(dot)org
[mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Friday, May 04, 2007 2:24 PM
To: Jose Blanco
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] order by question.

"Jose Blanco" <blancoj(at)umich(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly