Re: [HACKERS] A select with aggretion is failing, still subtle problems with aggregation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] A select with aggretion is failing, still subtle problems with aggregation
Дата
Msg-id 1343.925573150@sss.pgh.pa.us
обсуждение исходный текст
Ответ на A select with aggretion is failing, still subtle problems with ag gregation  (Michael J Davis <michael.j.davis@tvguide.com>)
Ответы cache startup file  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] A select with aggretion is failing, still subtle problems with aggregation  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
Дерево обсуждения 
Michael J Davis <michael.j.davis@tvguide.com> writes:
> The following select fails:
>> select invoiceid + 3 as type, memberid, 1, max(TotShippingHandling) 
>> from InvoiceLineDetails 
>> where TotShippingHandling <> 0 
>> group by type, memberid limit 10;
> ERROR:  replace_agg_clause: variable not in target list

Yeah, "GROUP BY" on anything but a primitive column is still pretty
hosed.  I'm going to try to work on it this weekend.
        regards, tom lane

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

Предыдущее
От: Vadim Mikheev
Дата:
Сообщение: I'm planning some changes in lmgr...
Следующее
От: Vadim Mikheev
Дата:
Сообщение: Re: [HACKERS] A patch for FATAL 1:btree: BTP_CHAIN flag was expected