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...
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
