Re: [GENERAL] trigger update delete - found it

2005-07-03 Thread Sim Zacks
I found the TG_OP variable which tels me which operation is currently being done. "Sim Zacks" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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. > > T

[GENERAL] trigger update delete

2005-07-03 Thread Sim Zacks
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 ..