At 03:37 PM 18/07/2006, you wrote:

>So how do you do
>
>IF OLD.ID <> NEW.ID THEN ...
>
>Where ID is the returned value in the current iteration of the for
>select?

You can't. I retract my comment about Alexandre's theory. It can't
work. FTR, triggers don't operate on SELECT statements so, even
assuming one had gone through an excruciating process of getting all
of the metadata info about each column, in order to construct a valid
DML statement, one would still be going through a revolving door of
recursion trying to perform an EXECUTE STATEMENT DML on the current row...

./heLen