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