How can I write trigger on a columns insert/update?

 

 

CREATE TRIGGER mytrigger

BEFORE

INSERT OR UPDATE

          OF mycolumn ON mytable

FOR EACH ROW

          EXECUTE PROCEDURE myfunction();

 

I am getting error “syntax error at or near "OF"

 

Thanks

 

Reply via email to