Received: from chmls05.mediaone.net (ne.mediaone.net [24.128.1.70]) by hub.org (8.8.8/8.7.5) with ESMTP id UAA25670 for ; Thu, 28 May 1998 20:35:13 -0400 (EDT) Received: from [24.128.86.181] (padovani.ne.mediaone.net [24.128.86.181]) by chmls05.mediaone.net (8.8.7/8.8.7) with ESMTP id UAA05955 for ; Thu, 28 May 1998 20:35:10 -0400 (EDT) Message-Id: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Thu, 28 May 1998 20:36:36 -0400 To: pgsql-sql@postgresql.org From: Pierre Padovani Subject: Triggers and SQL functions 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