Ok, it seem that is not what I am seeking.
I have a triggered function that works quite well on an insert into a table.
What I would like to do is trigger that same function when conditions are
updated in an other table.
I'm trying to avoid having to copy the whole function over to an update
trigger.
An other method would be to have the function triggered by a separate table and
then insert (then delete) a value into that table to trigger the function - but
I am hoping someone can come up with another way?
Bob
----- Original Message -----
From: Jonah H. Harris
To: Bob Pawley
Cc: John R Pierce ; pgsql-general@postgresql.org
Sent: Friday, June 26, 2009 10:30 AM
Subject: Re: [GENERAL] Need help using function
On Fri, Jun 26, 2009 at 1:28 PM, Bob Pawley <rjpaw...@shaw.ca> wrote:
However, perhaps I don't understand the idea of a function.
Please review the manual for examples.
http://www.postgresql.org/docs/8.3/static/plpgsql.html
Specifically, http://www.postgresql.org/docs/8.3/static/plpgsql-structure.html
--
Jonah H. Harris, Senior DBA
myYearbook.com
