Tom Lane wrote:
>
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > BTW I have a question about this example.
> > Session 2 deletes no row because *session 1* already
> > deleted the rows but the session_del rule seems to
> > be invoked. Is it a right behavior ?
>
> Certainly the rule should be invoked --- whether it finds any rows
> cannot be determined until it's invoked, anyhow. Remember a rule
> is not a trigger, it is a transform applied to the query before
> we begin execution.
If it's right, my way is to not use our rule system.
regards,
Hiroshi Inoue