Hi, A quick question: which is better (in terms of speed of execution):
CREATE TRIGGER x BEFORE INSERT ON y WHEN expr BEGIN SELECT RAISE(ABORT, 'message'); END; ... or ... CREATE TRIGGER x BEFORE INSERT ON y BEGIN SELECT RAISE(ABORT, 'message') WHERE expr; END; Or are the two, for intents and purposes, identical? I'd imagine the first form could be much better when the body of the trigger has more than one statement, but are there additional benefits of one over the other if, for example, 'expr' utilises an indexed column? Or does sqlite simply append the WHEN clause into the WHERE clause of the statement(s) in the trigger body? Thanks! Andy _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
