Update and trigger - Mailing list pgsql-sql

From Medi Montaseri
Subject Update and trigger
Date
Msg-id 8078a1730806101845x620d9f72p204d3cf94c0eb612@mail.gmail.com
Whole thread Raw
Responses Re: Update and trigger  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Update and trigger  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-sql
Hi,<br /><br />I need to increament a counter such as myTable.Counter of type integer everytime myTable.status a
booleancolumn is updated. Can you help me complete this...<br /><br />create trigger counter_trigger after update on
myTable.counter<br /> execute procedure 'BEGIN statement; statement; statement END'<br /><br />Q1- how do I narrow the
eventto "update on a column not a row"<br />Q2- can I just provide an inline procedure for the execute<br /><br
/>Thanks<br/> Medi<br /> 

pgsql-sql by date:

Previous
From: "Medi Montaseri"
Date:
Subject: Re: Conceptual Design Question
Next
From: "A. Kretschmer"
Date:
Subject: Re: Update and trigger