TRIGGER - Mailing list pgsql-general

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!