Scara Maccai <m_lists(at)yahoo(dot)it> wrote:
> What am I doing wrong?
> [function which uses INSERT/UPDATE/DELETE statements to try to force
> order of rows in heap]
You seem to be assuming that the rows will be in the table in the
sequence of your inserts. You might be better off with a CLUSTER on
some index. (There are a few other options, like TRUNCATE / INSERT or
SELECT INTO / DROP TABLE / ALTER TABLE RENAME -- but CLUSTER is
probably the safest, easiest way to go.)
-Kevin