On Thu, 2005-05-19 at 04:35, Richard Huxton wrote:
Dinesh Pandey wrote:
How can I write trigger on a columns insert/update?
CREATE TRIGGER mytrigger
BEFORE
INSERT OR UPDATE
OF mycolumn ON mytable
You don't I'm afraid. It's not a feature that's supported yet. You have
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
Dinesh Pandey wrote:
How can I write trigger on a columns insert/update?
CREATE TRIGGER mytrigger
BEFORE
INSERT OR UPDATE
OF mycolumn ON mytable
You don't I'm afraid. It's not a feature that's supported yet. You have
to check which column(s) were changed in your functions.
It is on