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

From: "Dinesh Pandey" <dpandey(at)secf(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How can I write trigger on a columns insert/update?
Date: 2005-05-19 07:56:50
Message-ID: 20050519080145.3DDBE52802@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Omachonu Ogali 2005-05-19 08:31:49 error explanation
Previous Message Samer Abukhait 2005-05-19 07:11:39 Re: Executing Dynamic DDL