Re: Re[2]: [Firebird-Architect] ORs in Where statement
Author
Alexandre Kozlov
Post date
2003-06-13T04:21:17Z
----- Original Message -----
From: Doug Chamberlin <yahoogroups@...>
Date: Thursday, June 12, 2003 9:36 pm
Subject: Re[2]: [Firebird-Architect] ORs in Where statement
> At 6/12/2003 08:08 PM (Thursday), Daniel Rail wrote:
> >- Complete evaluation is sometimes convenient when one operand is a
> > function with side effects that alter the execution of the program
>
> This is poorly stated. By definition "side effects" do not alter
> the result
> of the expression evaluation (what I think you refer to as "the
> execution
> of the program") but they can nevertheless be important. If I
> wrote a UDF
> which logs execution somewhere I think would want it called
> wherever I used it.
I'd prefer not to overload functions with side effect.
It's more safety to use them in short-curcuit evaluation expressions
which are more appropreate in common logical sense than full-evaluation.