Re: [HACKERS] Counting bool flags in a complex query

> Hi.
> 
> I think I've created a monster...
> 
...
> 
> My final problem is to count all the messages with flagnew set to true.
> The only way I can think to do this is to convert the bool value to a 1 or
> 0 (which I think should be a standard conversion anyway) and run a sum()
> on them.
> 
> 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?
> 
> -Michael

Of course, you could always use count() and a 'WHERE flagnew' clause...

Duane