| 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: | Whole Thread | Raw Message | 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 |