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 [EMAIL PROTECTED])
