Triggers and SQL functions

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

Browse pgsql-sql by date

  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