Hi,

> > What about deleting the old row, in a "BEFORE INSERT" trigger?
> > Insertion would stay insertion. This should work.

You could use a view with triggers on. Create a view that maps to
the table in question and add the triggers to it. Then use the view.

Records inserted into the view will fire the trigger which can
then insert or update the underlying table.

Regards
Ian Newby