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
