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