Function and trigger problem - Mailing list pgsql-sql

From Adam H. Pendleton
Subject Function and trigger problem
Date
Msg-id 000f01bea14b$079ef670$bdd0be80@belvoir.army.mil
Whole thread Raw
In response to Re: [SQL] Updating and null values.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
I use the following code to create a function:

create function employee_stats_update() returns int4as 'insert into employee_stats values ( new.employee_name); select
1as ignore_this'
 
language 'plpgsql';


Then I create the following trigger:

create trigger update_employee_statsbefore insert on employee_master for each row execute procedure
employee_stats_update();

This is what I get back when I try to create the trigger:

ERROR:  CreateTrigger: function employee_stats_update () does not exist

Adam



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Updating and null values.
Next
From: Michael J Davis
Date:
Subject: RE: [SQL] Function and trigger problem