Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] A select with aggretion is failing, still subtle problems with aggregation - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] A select with aggretion is failing, still subtle problems with aggregation
Date
Msg-id 1343.925573150@sss.pgh.pa.us
Whole thread Raw
In response to A select with aggretion is failing, still subtle problems with ag gregation  (Michael J Davis <michael.j.davis@tvguide.com>)
Responses cache startup file
Re: [HACKERS] A select with aggretion is failing, still subtle problems with aggregation
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Vadim Mikheev
Date:
Subject: I'm planning some changes in lmgr...
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] A patch for FATAL 1:btree: BTP_CHAIN flag was expected