--Thanks Tom!
--That's just what I needed!
-X
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Tuesday, March 19, 2002 10:19 AM
> Wonder if it is possible to get multiple counts
> from ONE query using the CASE statement.
If I'm understanding you correctly, you can't do what you want with
a single aggregate function call, because that will only give you
one result.
Consider something like
select
sum(case when logic = '1' then 1 else 0 end),
sum(case when logic = '2' then 1 else 0 end),
sum(case when logic = '3' then 1 else 0 end)
from ...
I also wonder whether you aren't reinventing the notion of GROUP BY.
F'r instance
select logic, count(*) from ... group by logic;
regards, tom lane