> When I read the docs about RULEs I remember seeing that an unqualified RULE > was needed otherwise PG wouldn't know that the operation was complete and > would fail. I haven't used them, but I believe that you have two options: > - use a RULE with your filtering conditions AND add an unqualified RULE that > is always run > - use an unqualified RULE and call a function that will perform the action > for you on the right tables > I believe the second solution leads to cleaner code and is easier to update / > debug. But I haven't tried it...
Thanks for the Reply, I will try creating functions called from the rule as you suggest. I would also be enterested in hearing of any other solutions that anyone might have. Also, I am still curious about what preresequites must be meet in order to use the WHERE predicate of a rule. Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
