Re: [HACKERS] Counting bool flags in a complex query - Mailing list pgsql-hackers

> Unless anyone can come up with a better way to do this, What is the best
> way to implement a conversion from bool to int?

Try
 select sum(case when bfield = TRUE then 1 else 0 end) from table;

It works for me...
            - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California