RULES - Mailing list pgsql-sql

From J.Fernando Moyano
Subject RULES
Date
Msg-id 01052205563802.07510@txino.mikasa.eh
Whole thread Raw
List pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


I need something like this .....

CREATE RULE piezas_add ASON insert TO piezasDO update materia_prima set usadas=(usadas+1)where
n_material=new.n_material;

CREATE RULE piezas_delete ASON delete TO piezasDO update materia_prima set usadas=(usadas-1)where
n_material=old.n_material;

Inserting all is OK.
... but in deleting operations nothing changes.

Can someone help me ??

And .... i would like to do the same when updating ....

Can i do something like this ?? 
What is the rigth syntax ??
Must i create 2 rules to perform the action ???

CREATE RULE piezas_update ASON update TO piezas.n_materialDO            update materia_prima set usadas=(usadas-1)
where          n_material=old.n_material           ???WHAAAT???           update materia_prima set usadas=(usadas+1)
where          n_material=new.n_material                    
 
thanks !!!

fer

- -- 
Fernando Moyano

Frase del día:
- --------------
El que retiene algo que no necesita es igual a un ladrón. (M Gandhi)

(*) SymeX ==> http://symex.lantik.com
(*) WDBIL ==> http://wdbil.sourceforge.net
(*) Informate sobre LINUX en http://www.linux.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7CjfWoZaf9MvtDvcRAkYbAJ9VfQGtF4NCQ8nOKegtLPKn0NwX5ACeLA7O
wyQnOfKGH1xRYnYBtB6jvW8=
=OB6B
-----END PGP SIGNATURE-----


pgsql-sql by date:

Previous
From: Sandhya Bellave
Date:
Subject: Define timestamp with no timezone
Next
From: Bruce Momjian
Date:
Subject: Re: how to check presence of a function and set permissions?