I found the TG_OP variable which tels me which operation is currently being done. "Sim Zacks" <sim@xxxxxxxxxxxxxx> wrote in message news:da83sd$1i7g$1@xxxxxxxxxxxxxxx > 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? > > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
