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