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" usa
Hello,
i find i must turn once again to the list for help, in what
is probably another silly request.
I have a view (made of 4 tables) and now find that users
need to have the view different based on some criteria from the
database. its. well. its rather icky to go into. but i can
Stef Telford wrote:
>
> Hello,
> i find i must turn once again to the list for help, in what
> is probably another silly request.
That's what the list is for, and it's only silly if you already know the
answer :-)
> The long and short of it is this, I would like the view to
> re
Richard Huxton wrote:
> That's what the list is for, and it's only silly if you already know the
> answer :-)
well, i do agree that the only stupid question is the one not asked
but there are some questions that are universally stupid and jst
hoped this wasnt one of them ;>
> > The long
"J.Fernando Moyano" <[EMAIL PROTECTED]> writes:
> 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
