From: Martín Marqués <martin@bugs.unl.edu.ar>
To: J.Fernando Moyano <txinete@wanadoo.es>
To: pgsql-sql@postgresql.org
Subject: Re: RULES
Date: Tue, 22 May 2001 10:44:06 +0300
Message-ID: <01052210440603.28396@bugs> (raw)
In-Reply-To: <01052213190000.01962@txino.mikasa.eh>
References: <01052213190000.01962@txino.mikasa.eh>
On Mar 22 May 2001 20:19, J.Fernando Moyano wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> Well ... i'm testing carefully the two rules ==>
>
> 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 is OK.
> Deleting is broken if it deletes more than one row. The rule is executed
> only one time each delete command, and not one time each deleted row.
>
> It's this OK ??? Am i wrong ???
> It's a "feature" ?? ;-)
That's the right behaviour!
Each time you do a delete, besides the delete, it will execute the update....
If more then one row is deletes, update.... gets executed only once.
You'll have to do more advance programing there. See if count(*) can help you
in any way.
I see you have to update usadas=(usadas-1). Try something like:
usadas=(usadas-(select count(*) from piezas WHERE condition_delete) )
Saludos... :-)
--
Cualquiera administra un NT.
Ese es el problema, que cualquiera administre.
-----------------------------------------------------------------
Martin Marques | mmarques@unl.edu.ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------
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: martin@bugs.unl.edu.ar, txinete@wanadoo.es
Subject: Re: RULES
In-Reply-To: <01052210440603.28396@bugs>
* 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