Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> COUNT(*) can't skip nulls because there is no specified column,
> but why does COUNT(col) skip nulls --- again, inconsistent.
I disagree -- one is counting rows, the other is counting rows with
a value in that column. I guess one could criticize the syntax for
specifying that as non-obvious, but it seems pretty reasonable to
me.
-Kevin