I'm trying to do something like this:
CREATE RULE piezas_delete AS
ON delete TO piezas
DO update materia_prima set usadas=(usadas-1)
where n_material=old.n_material;
The rule is created. OK .... but the action doesn't run like it's supossed.
¿What is wrong?
Is "old" usable with "ON DELETE" rules ???
I think delete action its performed AFTER rule action .... ¿OK?
So ... it's possible to access field values of delete affectted registers?
--
Fernando Moyano
Frase del día:
--------------
No hay cita. Solo son imaginaciones tuyas!!.
(*) SymeX ==> http://symex.lantik.com
(*) WDBIL ==> http://wdbil.sourceforge.net
(*) Informate sobre LINUX en http://www.linux.org
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
