RE: [SQL] Function and trigger problem

Trigger functions must return OPAQUE (OLD or NEW).

-----Original Message-----From:    Adam H. Pendleton [SMTP:apendleton@vgsinc.com]Sent:    Tuesday, May 18, 1999 10:25
AMTo:   pgsql-sql@hub.orgSubject:    [SQL] Function and trigger problem
 
I use the following code to create a function:
create function employee_stats_update() returns int4 as 'insert into employee_stats values (  new.employee_name);
select1 as ignore_this'language 'plpgsql';
 

Then I create the following trigger:
create trigger update_employee_stats before 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