Thanks for your interest,
I try also this but i receive the error :
ERROR: ProcedureCreate: sql functions cnnot return type "opaque"
ERROR: CreateTrigger: Function delartfather() does not exist
here is my code :
CREATE FUNCTION DelArtFather()
RETURNS opaque
AS '
DELETE FROM TArticles WHERE IdArtFather = OLD.IdArt;
SELECT 1 AS ignore_this
'
LANGUAGE 'sql';
CREATE TRIGGER trigger_TArticles
BEFORE DELETE ON TArticles
FOR EACH ROW EXECUTE PROCEDURE DelArtFather();
"Stephan Szabo" <sszabo@megazone23.bigpanda.com> a �crit dans le message
news: Pine.BSF.4.21.0103121829380.98920-100000@megazone23.bigpanda.com...
>
> Trigger functions need to take no arguments and return
> opaque. You can use NEW or OLD inside the function and
> arguments given in the create trigger statement
> are passed into the function in a special way (in
> plpgsql, it's TG_ARGV[] i believe)
>
> On Fri, 9 Mar 2001, De Leeuw Guy wrote:
>
> > 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"
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)