Re: sum(bool)? - Mailing list pgsql-sql

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      peter_e@gmx.net       http://yi.org/peter-e/