> 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