Re: [SQL] sum(bool)?

[Peter Eisentraut]

Olaf Zanger writes:

> i'd like to add up the "true" values of a comparison like
>
> sum(a>b)

sum(case when a>b then 1 else 0 end)

of maybe even just

select count(*) from table where a>b;

-- 
Peter Eisentraut      [EMAIL PROTECTED]       http://yi.org/peter-e/