RE: [SQL] Function and trigger problem

Trigger functions must return OPAQUE (OLD or NEW).

-----Original Message-----
From: Adam H. Pendleton [SMTP:apendleton(at)vgsinc(dot)com]
Sent: Tuesday, May 18, 1999 10:25 AM
To: pgsql-sql(at)hub(dot)org
Subject: [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);
select 1 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