When my RULE takes the form of:
CREATE RULE name AS ON INSERT TO table DO 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 *OLD* being initialized differently for an
UPDATE than for an INSERT.
I'd like to know what's going on so I can be confident I'm writing my rules
correctly.
Thanks all.
-------------------------------------------
jtocci
Fort Wayne, IN