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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Phantom row from aggregate in self-join in 6.5
Дата
Msg-id 14532.932741325@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Phantom row from aggregate in self-join in 6.5  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Ответы Re: [HACKERS] Phantom row from aggregate in self-join in 6.5  ("D'Arcy" "J.M." Cain <darcy@druid.net>)
Список pgsql-hackers
Thomas Lockhart <lockhart@alumni.caltech.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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Index not used on simple select
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] RFC: Security and Impersonation