Thread

Triggers and SQL functions

pierre@desertmoon.com — 1998-05-29T00:36:36Z

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