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
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 |