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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
