Michael J Davis <michael(dot)j(dot)davis(at)tvguide(dot)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