-----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)
wheren_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" ?? ;-)
Thanks
- --
Fernando Moyano
Frase del día:
- --------------
¡CocaCola esasín! ¡prrrrrrrrrts, bruuuuuuuups!
(*) 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
iD8DBQE7Cp+HoZaf9MvtDvcRAqV/AKCQLhl34VF3sfPt3O5i5w5MFpcZRQCgmm5b
duRciSRJhzTJLuhFrNLUcWQ=
=It2U
-----END PGP SIGNATURE-----