Re: [SQL] Conditional rule?

[Tom Lane]

"=?iso-8859-1?B?QW5kcukgTuZzcw==?=" <[EMAIL PROTECTED]> writes:
> Secondly, I miss one final idea, when a delete is performed on the
> b_news_unpublished table, I would like to set up a rule or procedure that
> sets the time value to null in b_news for each row that is affected by the
> delete. I understand that the OLD and NEW objects are accessible only during
> UPDATE or INSERT operations, so I can't quite see how to do this...

I might be wrong, but I thought the way it works is:
        INSERT: "NEW" refers to to-be-inserted row
        UPDATE: "OLD" is old row state, "NEW" is planned new row state
        DELETE: "OLD" holds row to be deleted

                        regards, tom lane