Is it possible to create a trigger that calls a custom function and passes
in NEW.*? To break that question down:
1) I know it's possible to create custom functions that take a variable
number of parameters.
2) I'm *assuming* if you pass a "*" into that function, it'll just call
that function with however many columns are available. For example, this
would call myFunc() with two parameters:
CREATE TABLE foo ( colA INTEGER, colB TEXT );
SELECT myFunc( * ) FROM foo;
3) It seems that there is a way to create a custom trigger that has no
byproduct but to call SELECT. The only reason I can imagine you'd want to
do that is to call a custom function. But can I call that function with
all columns using a *? (I can't quite figure this out from the docs alone.)
CREATE TRIGGER myFuncOnFooInsert AFTER INSERT ON foo
BEGIN
SELECT myFunc( NEW.* );
END
Are these assumptions correct, and should the above generally work? My
goal is to execute myFunc() every time there's an INSERT/UPDATE/DELETE on a
given table -- but I want myFunc() to be reusable and not need to know the
structure of the table it's being called on. Thanks, as always, I
appreciate your help!
-david
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
