Thread: Create trigger problem :

Create trigger problem :

From
"De Leeuw Guy"
Date:
Hi all,

I try this :

CREATE FUNCTION DelArtFather(INT4)

RETURNS INT4

AS '

DELETE FROM TArticles WHERE IdArtFather = $1;

SELECT 1 AS ignore_this

'

LANGUAGE 'sql';

CREATE TRIGGER trigger_TArticles

BEFORE DELETE ON TArticles

FOR EACH ROW EXECUTE PROCEDURE DelArtFather(old.IdArt);

and i obtain this error :

ERROR: parse error at or near "old"

How can i correct my command ??

Thanks in advance

Guy De Leeuw