Matthew Schumacher <matt.s@aptalaska.net> writes:
> I'm having trouble getting the rule system to work on updates that do
> not match the where clause.
You did not say what you mean by "doesn't work", but what I suspect you
are getting bit by is that ON UPDATE rules fire before the original
query is done. By the time the original query executes, you've inserted
a row into accounting_tab and so its added condition fails.
regards, tom lane