Postgres Pro
Downloads
Home   >   mailing lists

Re: Clustered table order is not preserved on insert - Mailing list pgsql-general

From Douglas McNaught
Subject Re: Clustered table order is not preserved on insert
Date
Msg-id 87u08gduw3.fsf@suzuka.mcnaught.org
Whole thread Raw
In response to Clustered table order is not preserved on insert  ("Andrus" <eetasoft@online.ee>)
List pgsql-general
Tree view 
"Andrus" <eetasoft@online.ee> writes:

> Why postgres 8.1.3 changes order ?
> How to preserve order in newr without adding extra field to report table ?

You are never guaranteed any order in a result set unless you use
ORDER BY in the query.  Because PG treats UPDATE as DELETE + INSERT,
the table ordering changes all the time.

-Doug

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Clustered table order is not preserved on insert
Next
From: Richard Huxton
Date:
Subject: Re: Clustered table order is not preserved on insert