Re: Create trigger problem :

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" <G.De_Leeuw@eurofer.be> wrote in message
news:98imbv$2hk2$1@news.tht.net...
> 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
>
>
>