From: J.Fernando Moyano <txinete@wanadoo.es>
To: pgsql-sql@postgresql.org
Subject: RULES
Date: Tue, 22 May 2001 05:56:38 -0400
Message-ID: <01052205563802.07510@txino.mikasa.eh> (raw)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I need something like this .....
CREATE RULE piezas_add AS
ON insert TO piezas
DO update materia_prima set usadas=(usadas+1)
where n_material=new.n_material;
CREATE RULE piezas_delete AS
ON delete TO piezas
DO 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 AS
ON update TO piezas.n_material
DO
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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: txinete@wanadoo.es
Subject: Re: RULES
In-Reply-To: <01052205563802.07510@txino.mikasa.eh>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox