From: Scott Marlowe <scott.marlowe@gmail.com>
To: Nacef LABIDI <nacef.l@gmail.com>
Cc: 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 09:16:44 -0600
Message-ID: <dcc563d10804220816s3ae482d3r7abc24518bb6d378@mail.gmail.com> (raw)
In-Reply-To: <f16f7ea00804220600t2ef252e5p9e4f97cffa13b8d0@mail.gmail.com>
References: <f16f7ea00804220254i671e446au7c50dca45dea10d7@mail.gmail.com>
<480DDE26.50405@postnewspapers.com.au>
<480DFC7F.A3DD.0030.0@indicator.be>
<f16f7ea00804220600t2ef252e5p9e4f97cffa13b8d0@mail.gmail.com>
On Tue, Apr 22, 2008 at 7:00 AM, Nacef LABIDI <nacef.l@gmail.com> wrote:
> Thank you all for your useful comments.
>
> I have tried to order my records as you said and got it work as I wanted.
Cool beans! I was just watching this conversation, but wanted to
point out that using the methods mentioned in this thread (i.e. ones
that use order by) is good practice. It's quite possible that at some
point in the future the storage engine of MS-SQL could change and
break your application on that platform. By using the order by
method, you ensure you're using a method that works today and in the
future on all major platforms.
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: scott.marlowe@gmail.com, 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: <dcc563d10804220816s3ae482d3r7abc24518bb6d378@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