Matthew Schumacher <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
