Multiple Actions in TRIGGERS - syntax help?
Posted in 1995
Topics: Triggers, Constraints & Referential Integrity
Anyone know the correct syntax to implement a trigger that
performs multiple actions for a triggereing event? The triggers
manual refers to this as a possibility but shows no example
code that would describe the syntax.
CREATE TRIGGER t_kills2birdsINSERT ON table_1
REFERENCING NEW AS newrow
FOR EACH ROW ( insert into table_2, insert into table_3 )
What I need is the *SYNTAX* for the FOR EACH ROW line - ie:
how do you separate the multiple actions performed for each row?
FOR EACH ROW (insert into t_2 values (...), insert into t_3 values (...))
or
FOR EACH ROW (insert into t_2 values (...); insert into t_3 values (...))
or
FOR EACH ROW (insert into t_2 values (...) insert into t_3 values (...))
or something else entirely
anyone know?
Mike
--
Michael Stenzler <rpcg@panix.com>
RPCG, Inc. 70 Hudson St. Hoboken, NJ 07030
All opinions expressed herein belong to me - not RPCG.