Re: Select query order

Use oid as the sort order SELECT *,oid from table order by oid

--- On Wed, 3/24/10, Sean Davis <sdavis2@mail.nih.gov> wrote: From: Sean Davis <sdavis2@mail.nih.gov> Subject: Re: [NOVICE] Select query order To: "Krithinarayanan Ganesh Kumar" <krithinarayanan@gmail.com> Cc: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org> Date: Wednesday, March 24, 2010, 9:13 AM On Wed, Mar 24, 2010 at 8:06 AM, Krithinarayanan Ganesh Kumar <krithinarayanan@gmail.com> wrote: > Hi All, > > I am aware that Select query does not guarantee the order of the rows > returned ( The rows are returned in whatever order the system finds fastest > to produce). > > Is there any way to SELECT the rows in the same order of insertion ? The > problem is there is no Primary Key in the table, I am having only a > composite key. So I cannot ORDER BY pk also. Unless you have stored something in the table that correlates with the order of insertion, I don't know of a way to get at the insertion order as this information is not tracked by Postgresql. Sean -- Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-novice

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com