Re: Need help using function

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(at)postgresql(dot)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 <rjpawley(at)shaw(dot)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