...
> I don't really consider this a bug; at least, fixing it would imply not
> const-simplifying the result expressions of CASEs, which is a cure far
> worse than the disease IMHO. Does anyone think we *should* allow CASE
> to defeat const-simplification?
No. Constant-folding during parsing sho
[EMAIL PROTECTED] writes:
> In 7.2.1, Both the WHEN and THEN clauses of a CASE statement are evaluated, even if
>the WHEN clause evaluates to FALSE.
Not in the normal case.
> SELECT
> CASE
> WHEN 1 = 2 THEN 1 / 0
> WHEN 1 = 1 THEN 1.0
> END;
> ERROR: floating point exce
James Cole (colejatmsu.edu) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
CASE statement evaluation does not short-circut
Long Description
In 7.2.1, Both the WHEN and THEN clauses of a CASE statement are evaluated, even if
the WHEN clause evalu
