Thread: trigger update delete
I am trying to write a trigger function that will do something when either a row had been deleted or a field has been updated to null. The problem I am having is determining in the function if this is a delete or not. I would like to say: if this is delete trigger or new.field1 is null then ... end if new.field1 dies when it is a delete trigger, as it is supposed to. But I need the function to know the difference. Any thoughts?
I found the TG_OP variable which tels me which operation is currently being done. "Sim Zacks" <sim@compulab.co.il> wrote in message news:da83sd$1i7g$1@news.hub.org... > I am trying to write a trigger function that will do something when either a > row had been deleted or a field has been updated to null. > > The problem I am having is determining in the function if this is a delete > or not. I would like to say: > if this is delete trigger or new.field1 is null then > ... > end if > > new.field1 dies when it is a delete trigger, as it is supposed to. But I > need the function to know the difference. > > Any thoughts? > >