On Mon, 15 Sep 2003, Adam Kavan wrote:
> I am starting to work with rules. I think I have them down but the
> folowing one is giving me grief. It tells me that it has rewritten 100
> times and probably has looped. The columns ID and Location make up the
> primary key so I am sure that the result update should only effect one
> row. Anyone know what I am missing?
Rules are like a macro system, you can't generally get around loops by
using where conditions on the rule. You'll need to either break the
recursion by using something like a view or write the logic into a
before trigger.