Re: Conditional rule?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Conditional rule?
Дата
Msg-id 29738.964797211@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Conditional rule?  ("André Næss" <andre.nass@student.uib.no>)
Список pgsql-sql
"André Næss" <andre.nass@student.uib.no> 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 rowUPDATE: "OLD" is old row
state,"NEW" is planned new row stateDELETE: "OLD" holds row to be deleted
 
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: "André Næss"
Дата:
Сообщение: Re: Conditional rule?
Следующее
От: Henry Lafleur
Дата:
Сообщение: RE: RE: Re(2): optimize sql