Thread: Multiple rule action syntax

Multiple rule action syntax

From
Constantin Teodorescu
Date:
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