Thread: TRIGGER
I’m having a problem with creating triggers…
Here’s my code:
CREATE FUNCTION copy_email(varchar)
RETURNS varchar
AS ‘SELECT email AS email INTO temp_agegroup FROM basic_information;’
LANGUAGE ‘sql’;
OUPTPUT: CREATE ß- successful, right?
CREATE TRIGGER trig_test
AFTER INSERT OR UPDATE
ON basic_information
FOR EACH ROW
EXECUTE PROCEDURE copy_email(); ß- also tried copy_email(varchar), copy_email(test), copy_email(‘test’)
OUTPUT: ERROR: function copy_email does not exist
Please help me….
Thanks!
The docs are not very clear, but I think that trigger functions must all
return opaque.
--rob
----- Original Message -----
From: "HC Mercy T. de Vera" <mercy@edsamail.com>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, January 17, 2001 10:11 PM
Subject: TRIGGER
>
> I'm having a problem with creating triggers.
>
> Here's my code:
>
> CREATE FUNCTION copy_email(varchar)
> RETURNS varchar
> AS 'SELECT email AS email INTO temp_agegroup FROM basic_information;'
> LANGUAGE 'sql';
>
> OUPTPUT: CREATE <--- successful, right?
>
>
>
> CREATE TRIGGER trig_test
> AFTER INSERT OR UPDATE
> ON basic_information
> FOR EACH ROW
> EXECUTE PROCEDURE copy_email(); <--- also tried copy_email(varchar),
> copy_email(test), copy_email('test')
>
> OUTPUT: ERROR: function copy_email does not exist
>
>
> Please help me..
> Thanks!
>
>