From: Nacef LABIDI <nacef.l@gmail.com>
To: Bart Degryse <Bart.Degryse@indicator.be>
Cc: Craig Ringer <craig@postnewspapers.com.au>
Cc: pgsql-sql@postgresql.org, "Roland Voegtli" <voegtli@scnat.ch>
Subject: Re: After updating dataset the record goes to the end of thedataset
Date: Tue, 22 Apr 2008 15:00:21 +0200
Message-ID: <f16f7ea00804220600t2ef252e5p9e4f97cffa13b8d0@mail.gmail.com> (raw)
In-Reply-To: <480DFC7F.A3DD.0030.0@indicator.be>
References: <f16f7ea00804220254i671e446au7c50dca45dea10d7@mail.gmail.com>
<480DDE26.50405@postnewspapers.com.au>
<480DFC7F.A3DD.0030.0@indicator.be>
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.Degryse@indicator.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.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: nacef.l@gmail.com, Bart.Degryse@indicator.be, craig@postnewspapers.com.au, voegtli@scnat.ch
Subject: Re: After updating dataset the record goes to the end of thedataset
In-Reply-To: <f16f7ea00804220600t2ef252e5p9e4f97cffa13b8d0@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox