Re: Unexpected behavior with CASE statement

Jimmy Choi escribió:
> This will work for this particular example. But what if my case
> statement is more complicated than that? Example:
>
> select
>    metric_type,
>    case metric_type
>       when 0 then
>          sum (1 / val)
>       when 1 then
>          sum (val)
>       when 2 then
>          max (val)
>       when 3 then
>          min (val)
>    end as result
> from metrics
> group by metric_type

This doesn't make sense.  Use separate output columns for the different
aggregates.

--
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"Crear es tan difícil como ser libre" (Elsa Triolet)