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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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!
>
>
