I need to increament a counter such as myTable.Counter of type integer
everytime myTable.status a boolean column is updated. Can you help me
create trigger counter_trigger after update on myTable.counter
execute procedure 'BEGIN statement; statement; statement END'
Q1- how do I narrow the event to "update on a column not a row"
Q2- can I just provide an inline procedure for the execute
pgsql-sql by date
|Next:||From: A. Kretschmer||Date: 2008-06-11 05:21:07|
|Subject: Re: Update and trigger|
|Previous:||From: Medi Montaseri||Date: 2008-06-10 20:11:23|
|Subject: Re: Conceptual Design Question|