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) ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
