Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Clustered table order is not preserved on insert
- From: Douglas McNaught <doug(at)mcnaught(dot)org>
- To: "Andrus" <eetasoft(at)online(dot)ee>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Clustered table order is not preserved on insert
- Date: Wed, 26 Apr 2006 15:00:44 -0400
"Andrus" <eetasoft(at)online(dot)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
- Follow-Ups:
- Re: Clustered table order is not preserved on insert
- From: Andrus
- Re: Clustered table order is not preserved on insert
- References:
- Clustered table order is not preserved on insert
- From: Andrus
- Clustered table order is not preserved on insert
- Prev by Date: Clustered table order is not preserved on insert
- Next by Date: Re: Clustered table order is not preserved on insert
- Previous by thread: Clustered table order is not preserved on insert
- Next by thread: Re: Clustered table order is not preserved on insert
- Indexes: