Re: Odd error in complex query (7.2): Sub-SELECT uses un-GROUPed...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Odd error in complex query (7.2): Sub-SELECT uses un-GROUPed...
Дата
Msg-id 2151.1004472304@sss.pgh.pa.us
обсуждение
Ответ на Re: Odd error in complex query (7.2): Sub-SELECT uses un-GROUPed...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> Okay, I'm convinced: the problem is that the test for ungrouped vars
> used inside subselects is too simplistic.

Not only was that true, but the handling of GROUP BY expressions was
pretty grotty in general: they'd be re-evaluated at multiple levels of
the resulting plan tree.  Which is not too bad for "GROUP BY a+b",
but it's unpleasant when a complex subselect is involved.

I've committed fixes to CVS.
        regards, tom lane


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