Multiple rule action syntax

Поиск
Список
Период
Сортировка
От Constantin Teodorescu
Тема Multiple rule action syntax
Дата
Msg-id 3641AEA9.C2723EED@flex.ro
обсуждение исходный текст
Список pgsql-general
Hello,

in PostgreSQL 6.4 enhancements I found :

New rewrite system fixes many problems with rules and views(Jan)
  * Multiple rule actions are now supported, surrounded by parentheses

Could you give me please an example for this.

I want to define a rule on a table update that would update other two
tables, something like :

create rule misc_upd as on update to misc do
   (update stoc set stoc=stoc-old.cant where cod=old.cod),
   (update stoc set stoc=stoc+new.cant where cod=new.cod);

the above syntax doesn't work

Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

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

Предыдущее
От: Juan Carlos Castro y Castro
Дата:
Сообщение: Re: [GENERAL] November 4th, 1998: PostgreSQL v6.4 Released
Следующее
От: Mario Filipe
Дата:
Сообщение: RE: [GENERAL] age('now',date::datetime)