Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #6669: unique index w/ multiple columns and NULLs - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #6669: unique index w/ multiple columns and NULLs
Date
Msg-id 4FCC8E020200002500048003@gw.wicourts.gov
Whole thread Raw
In response to Re: BUG #6669: unique index w/ multiple columns and NULLs  (Bruce Momjian <bruce@momjian.us>)
Responses Re: BUG #6669: unique index w/ multiple columns and NULLs
List pgsql-bugs
Tree view 
Bruce Momjian <bruce@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

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #6669: unique index w/ multiple columns and NULLs
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #6669: unique index w/ multiple columns and NULLs