From: PFC <lists@boutiquenumerique.com>
To: lucas@presserv.org
To: pgsql-sql@postgresql.org
Subject: Re: New record position
Date: Wed, 30 Mar 2005 16:19:29 +0200
Message-ID: <op.sogferobth1vuj@localhost> (raw)
In-Reply-To: <20050330105017.miuieky7u64gscgc@www.presserv.org>
References: <20050330105017.miuieky7u64gscgc@www.presserv.org>
> Why it? I can't undestand why the new record location was change.
> Shouldn't it
> apper at the LAST record???
> What need I do??
> Thank you.
The SQL spec specifies that if you don't use ORDER BY, well, the records
come out in any order they want. Actually it's the order they are on disk,
which is more or less random as inserting new records will fill the space
left by deleted ones, and vacuum full will compact them. If you want
order, use ORDER BY. If you want to order them in the order they were
inserted, order by a SERIAL PRIMARY KEY field...
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: lists@boutiquenumerique.com, lucas@presserv.org
Subject: Re: New record position
In-Reply-To: <op.sogferobth1vuj@localhost>
* 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