Re: After updating dataset the record goes to the end of thedataset - Mailing list pgsql-sql

From Bart Degryse
Subject Re: After updating dataset the record goes to the end of thedataset
Date
Msg-id 480DFC7F.A3DD.0030.0@indicator.be
Whole thread Raw
In response to Re: After updating dataset the record goes to the end of the dataset  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-sql
Probably what you mean is that you want the order in which the records were
originally inserted into the database. In that case add a serial to your table and
fetch the records like
SELECT * FROM tbl WHERE 1=1 ORDER BY [myserialfield]
It's not foolproof but will in many cases come close to what you seem to be trying
to achieve by not using 'order by'.

Nacef LABIDI wrote:
> Yes I don't issue any sort statement, and I indeed want the data to be show
> as it is stored in the database.

pgsql-sql by date:

Previous
From: "Nacef LABIDI"
Date:
Subject: Re: After updating dataset the record goes to the end of thedataset
Next
From: "Scott Marlowe"
Date:
Subject: Re: After updating dataset the record goes to the end of thedataset