| From: | Pierre Padovani <pierre(at)desertmoon(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Triggers and SQL functions |
| Date: | 1998-05-29 00:36:36 |
| Message-ID: | l03130302b193b2e73867@[24.128.86.181] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Can or will postgresql support trigger calls to sql defined functions?
When attempting this I get....
create function effect_of_add_prod(bpchar) returns boolean
as
'update developer
set developer_tot_prod = developer_tot_prod + 1
where exists (select developer_id
from developer
where developer_id = $1);
select true as ignore_this;'
language 'sql';
CREATE
create trigger add_product after insert
on product for each row
execute procedure effect_of_add_prod(product_developer);
ERROR: CreateTrigger: function effect_of_add_prod () does not exist
Searching through documentation reveals only mention of calls to C
functions...is there no way to call SQL functions?
-=pierre
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bernhard Matthias Ertl | 1998-05-29 18:09:15 | inheritance |
| Previous Message | M Simms | 1998-05-28 18:56:01 | oops and a question |