Re: Need help using function
| От | Bob Pawley |
|---|---|
| Тема | Re: Need help using function |
| Дата | |
| Msg-id | A423940DB3B4481D93713640225A8C8F@desktop обсуждение исходный текст |
| Ответ на | Need help using function ("Bob Pawley" <rjpawley@shaw.ca>) |
| Список | pgsql-general |
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. HarrisTo: Bob PawleySent: Friday, June 26, 2009 10:30 AMSubject: Re: [GENERAL] Need help using functionOn Fri, Jun 26, 2009 at 1:28 PM, Bob Pawley <rjpawley@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
В списке pgsql-general по дате отправления: