Justin Tocci [EMAIL PROTECTED] writes:
Thanks for the reply Tom, here's the rule that works:
CREATE RULE tquotehistory_update AS ON UPDATE TO vtquotehistory DO INSTEAD
(
INSERT INTO tquotehistory_log (ID, Item, Quote1, DemandCost1,
Quote2, DemandCost2, DueDate, POIntoInmass, Weeks,
When my RULE takes
the form of:
CREATE
RULE name AS ON INSERT TO tableDO INSTEAD ( UPDATE query ;INSERT
query);
The INSERT query doesn't fire and
there is no error. Putting the INSERT first allows them to both fire. Can anyone
tell me why? I think it has something to do with *NEW* and