Bruce Momjian <br...@momjian.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
-- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs