yes there is : http://www.postgresql.org/docs/7.4/interactive/sql-createtrigger.html
FOR EACH ROW FOR EACH STATEMENT This specifies whether the trigger procedure should be fired once for every row affected by the trigger event, or just once per SQL statement. If neither is specified, FOR EACH STATEMENT is the default. Philippe Poelvoorde wrote:
Hi, the syntax for creating a triggers is : CREATE TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW trigger_stmt Is there any other possibilities than "FOR EACH ROW" ? If I do : CREATE TABLE test(foo varchar(5)); CREATE TRIGGER trigger_name AFTER INSERT ON test FOR EACH ROW do_something; INSERT INTO test(foo) VALUES ('a'),('b'),('c');it would trigger trigger_name for the 3 inserts, right ? Any chance to trigger trigger_name only once at the end ???
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
