|
If I have an _expression_ (a or b)a where
a=TRUE and b=FALSE, why is b evaluated? Any true operand before an or operator
means the entire _expression_ is true … ---------------------------- EXAMPLE create or replace function pinsusers()
returns trigger as $$ declare msg varchar; begin --THROWS
EXCEPTION when ((TG_OP = 'INSERT') is TRUE “record old is not assigned
yet” msg
= ((TG_OP = 'INSERT') or (new.password<>old.password)); raise
exception '%',msg; return
new; end $$ language plpgsql; ------------------------------------------------------ TY J |
