Hi Tom,
Thanks for the explanation about standard sql.
The goodness of it must be accepted by faith. :-)
I still have a doubt about the result of the GROUP BY clause.
It seems to me that there's an inconsistence between the GROUP BY clause
and the unique index.
The GROUP BY clause, consider NUL
Jeff Davis wrote:
On Mon, 2012-06-04 at 11:56 -0400, Bruce Momjian wrote:
I get your point about COUNT(*) really counting rows, not values, but
why doesn't GROUP BY then skip nulls?
A while ago, I came to the conclusion that applying logic to extrapolate
the behavior of NULL is a bad i