Referencing the entire row in an insert trigger
505838May 20 2007 — edited May 21 2007I am trying to replace having to do the following sort of queries repeatedly by using a trigger to handle the second 2:
My first query inserts a row and the following 2 queries insert a reference to that row into 2 other tables
so I want to create a trigger which will insert the reference into the 2 other tables.
my problem: how do I get this reference in the trigger? I know I can get individual values using :NEW.Column but I can't seem to figure out how to get the whole row.
I can't select the row because its inside the trigger responding to it being inserted so I'd get that mutator error.