Multiple rule action syntax

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: PostgreSQL general <pgsql-general(at)postgreSQL(dot)org>
Subject: Multiple rule action syntax
Date: 1998-11-05 13:56:57
Message-ID: 3641AEA9.C2723EED@flex.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Memphisto 1998-11-05 14:13:35 insert problem.
Previous Message Juan Carlos Castro y Castro 1998-11-05 13:48:49 Re: [GENERAL] November 4th, 1998: PostgreSQL v6.4 Released