|Subject||Re: Case vs. update|
--- In firstname.lastname@example.org, "Ann W. Harrison"
> Case is a value expression, not an operator.Of course... next time I'll try thinking before posting ;-)
> There is a messiness in the Firebird handling of values that willbreak
> this particular example. The SQL standard specifies that the valuesvalues
> used as input to a set operation are the old values, even if new
> have been assigned to those fields. Firebird doesn't follow theto
> standard in that case, so the set statement that assigns a new value
> a will affect the results of the assignment to b.Is this still the case with Firebird 2.0?