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

Reply via email to