[EMAIL PROTECTED] writes:
> In my case we have an unconditional instead rule. The original query was an
> update and the instead rule replaced it with an update of another table; an
> update was replaced with an update. Then I should expect to see the status
> of the last query that was inserted by the instead rule. So I should not see
> a status of zero.
Well, you'll see the status of the last UPDATE executed due to a rule
... but that doesn't mean it couldn't have updated zero rows. It might
be worth pointing out here that conditional rules insert queries that
have the condition added to their WHERE clause; if the condition is
false then no rows are going to get processed.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
