Create trigger problem :

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

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