At 22:01 +0300 on 12/08/1999, Aaron Seigo wrote:
> the reason its shifting around is most probably due to the fact that there
> are updates being done to these fields (last updated, last to be
> selected)... the oids, however, will remain in the proper order...
This is true. PostgreSQL does no overwrites. When it updates a row, it
simply writes the updated row at the end of the file, invalidating the old
one. The results of a SELECT without ORDER BY are in the order the rows
appear in the file. The OIDs remain as they were, because they are written
in the updated row just like all the rest of the data.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
