From: hubert depesz lubaczewski <depesz@depesz.com>
To: Nacef LABIDI <nacef.l@gmail.com>
Cc: Roland Voegtli <voegtli@scnat.ch>
Cc: pgsql-sql@postgresql.org
Subject: Re: After updating dataset the record goes to the end of the dataset
Date: Tue, 22 Apr 2008 12:15:23 +0200
Message-ID: <20080422101523.GB17162@depesz.com> (raw)
In-Reply-To: <f16f7ea00804220310m26753072mec98ef0bc6bb2c9e@mail.gmail.com>
References: <f16f7ea00804220254i671e446au7c50dca45dea10d7@mail.gmail.com>
<3B256469-4A00-44C3-8EB8-F49FA9F7259A@scnat.ch>
<f16f7ea00804220310m26753072mec98ef0bc6bb2c9e@mail.gmail.com>
On Tue, Apr 22, 2008 at 12:10:41PM +0200, 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. But after updating a row (I don't update
> the ID, just some fields), it keeps its same place on the DB but jumps to
> the end of the dataset and by the way to the end of the DBGrid.
why do you think it stays in the same place in db?
besides - without "order by" you cannot depend on the order of rows.
basically i treat them as in "random" order (which is not true, but
helps me remember to never count on the "default" ordering.
depesz
--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)
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: depesz@depesz.com, nacef.l@gmail.com, voegtli@scnat.ch
Subject: Re: After updating dataset the record goes to the end of the dataset
In-Reply-To: <20080422101523.GB17162@depesz.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