| From: | "Nacef LABIDI" <nacef(dot)l(at)gmail(dot)com> |
|---|---|
| To: | "Bart Degryse" <Bart(dot)Degryse(at)indicator(dot)be> |
| Cc: | "Craig Ringer" <craig(at)postnewspapers(dot)com(dot)au>, pgsql-sql(at)postgresql(dot)org, "Roland Voegtli" <voegtli(at)scnat(dot)ch> |
| Subject: | Re: After updating dataset the record goes to the end of thedataset |
| Date: | 2008-04-22 13:00:21 |
| Message-ID: | f16f7ea00804220600t2ef252e5p9e4f97cffa13b8d0@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Thank you all for your useful comments.
I have tried to order my records as you said and got it work as I wanted.
Thank you again
On Tue, Apr 22, 2008 at 2:56 PM, Bart Degryse <Bart(dot)Degryse(at)indicator(dot)be>
wrote:
> 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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-04-22 15:16:44 | Re: After updating dataset the record goes to the end of thedataset |
| Previous Message | Bart Degryse | 2008-04-22 12:56:00 | Re: After updating dataset the record goes to the end of thedataset |