Josh Berkus wrote:
>
> Andreas,
>
> > 1) update test set a=0 -> trigger does its work
> > 2) update test set a=0, b=1, c=2 -> trigger does nothing
> > 3) update test set a=0, b=b, c=c -> trigger does nothing, but content of
> > a and b dont change either although touched
>
> > IF OLD.b=NEW.b wil
Hello Christoph Haller ,
> >
> > >So you want the trigger executed only if assignments to b and/or c do
Do sime thing like this use if /then /esle s block for the problem
In the first if blick check that b and c is null by the declaration of
IS NULL after that you run the update command as re
>
> >So you want the trigger executed only if assignments to b and/or c do
> >not appear within the update command. Right?
> >
>
> Right, that's what I want.
>
I'm afraid I have no idea how to accomplish that.
Regards, Christoph
---(end of broadcast)
