Trigger: what rows were deleted?

Started by Ciprian Popoviciover 21 years ago2 messagesgeneral
Jump to latest
#1Ciprian Popovici
ciprian@zuavra.net

I'm trying to make a trigger, fired by DELETE. The associated function
needs to know what rows were deleted in order to perform a DELETE in
another table as well. (Foreign keys are not acceptable.) I don't seem
to be able to find this kind of info being passed to the function. The
special vars don't seem to have something useful. The arguments to the
trigger could help, but can they be made dynamical? Is there any way
of identifying the affected rows?

--
Ciprian Popovici

#2Ciprian Popovici
ciprian@zuavra.net
In reply to: Ciprian Popovici (#1)
Re: Trigger: what rows were deleted?

Ignore my previous question. The special variable OLD is defined
for DELETE fired triggers as well.

--
Ciprian Popovici