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.
Hmm I may have misunderstood your explanation.
What I meant is
Session 2 invokes the session_del rule and really
updates a sis_user row by the rule though it deletes
no session row.
regards,
Hiroshi Inoue