How can I write trigger on a columns insert/update? - Mailing list pgsql-general

From Dinesh Pandey
Subject How can I write trigger on a columns insert/update?
Date
Msg-id 20050519080145.3DDBE52802@svr1.postgresql.org
Whole thread Raw
Responses Re: How can I write trigger on a columns insert/update?
List 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

 

pgsql-general by date:

Previous
From: Samer Abukhait
Date:
Subject: Re: Executing Dynamic DDL
Next
From: Omachonu Ogali
Date:
Subject: error explanation