Re: Clustered table order is not preserved on insert

"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