Instead of sending old.ldArt in as a parameter, try just referencing old inside the function body. So the function then has no argument. Mark "De Leeuw Guy" <[EMAIL PROTECTED]> wrote in message 98imbv$2hk2$[EMAIL PROTECTED]">news:98imbv$2hk2$[EMAIL PROTECTED]... > 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 > > > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
