G'day
I have a before-update trigger a bit like
....
REFERENCING OLD AS O NEW AS N
....
WHEN (N.STATUS 0
AND EXISTS (SELECT EXTREF FROM MY.ET
WHERE EXTREF=N.REF OR EXTREF=O.REF))
Updates should mostly fail the N.STATUS>0 clause, so I don't really want
to do the EXISTS for every update.
Will this perform short circuit evaluation, i.e. if N.STATUS is zero,
will it still evaluate EXISTS(select..) ?
Or should I move the EXISTS into an IF inside the trigger action?
--Greg Nash