On Fri, Jul 29, 2005 at 00:05:46 +0200, Havasvölgyi Ottó <[EMAIL PROTECTED]> wrote: > > This function deletes a row, and updates the pid field where pid is geater > than the deleted pid value, so that the gap caused by the deletion is not > present any more.
This isn't directly related to your problem, but why are you doing this? This is a pretty inefficient thing to be doing unless there is a business rule that there can't be gaps in the pid values. If you just want to number rows in reports, you should do that in your reporting application, not by continuously renumbering your records. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
