Re: [BUGS] BUG #6669: unique index w/ multiple columns and NULLs

2012-06-04 Thread jo
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

Re: [BUGS] BUG #6669: unique index w/ multiple columns and NULLs

2012-06-05 Thread jo
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