Re: [HACKERS] Phantom row from aggregate in self-join in 6.5

Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> writes:
> I don't recall which way I argued before (in fact, I don't recall this
> particular example), but I do remember arguing (with righteous
> conviction) that the query
> select count(*) from foo;
> should return a single row containing a zero value.

No argument about that one. It's the GROUP BY case that's at issue.

> Did we infer from
> that some behavior for "group by" (I can't recall any)? istm, at least
> today, that the behavior for the group-by is wrong,

IIRC, you were the main advocate of the position that the code's
existing behavior is correct. Does that mean I can go change it? ;-)

regards, tom lane