postgresql - sql - count of `true` values myCol ------ true true true false false null In the above table, if I do : select count(*), count(myCol); I get 6, 5 I get 5 as it doesn't count the null entry. How do I also count the number of true values (3 in the example)? (This is a simplification and I'm actually using a much more complicated expression within the count function) Edit summary: I al..