[SQL] CREATE TRIGGER ... FOR EACH STATEMENT

2004-11-07 Thread Mischa Sandberg
I notice a dearth of description of the FOR EACH STATEMENT flavour of triggers, even though OLD_TABLE and NEW_TABLE are mentioned. After years of Sybase & MSSQL, being able to deal with the entire INSERTED/DELETED rowsets in a trigger, rather than nibbling away row by row, has been a great effici

Re: [SQL] CREATE TRIGGER ... FOR EACH STATEMENT

2004-11-07 Thread Mischa Sandberg
Please ignore this, I just caught up with news in c.d.p.hackers Mischa Sandberg wrote: I notice a dearth of description of the FOR EACH STATEMENT flavour of triggers, even though OLD_TABLE and NEW_TABLE are mentioned. After years of Sybase & MSSQL, being able to deal with the entire INSERTED/DELE