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 по дате отправления: