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: | Raw Message | Whole Thread | 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 |