On Wed, Mar 24, 2010 at 8:21 AM, Francisco Leovey <fleovey@yahoo.com> wrote:
Use oid as the sort order
SELECT *,oid from table order by oid
Hi, Francisco. I hope you don't mind this going back to the list....
I wouldn't recommend this solution for several reasons including the fact that OIDs are not by default created for user tables. They are not guaranteed to be unique and even the insert order is not accurately tracked by them if there is a rollover. See here for details:
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.