Im having a problem with creating triggers
Heres 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!