Re: [HACKERS] Odd subselect in target list behavior WRT aggregates

2003-01-24 Thread Mike Mascari
Tom Lane wrote: "Mike Mascari" <[EMAIL PROTECTED]> writes: Hello. I have some code which generates subselects in the target list of a query and then aggregates the results. The code allows the user to determine the attributes of the aggregation. If the user chooses to aggregate on the same value

Re: [HACKERS] Odd subselect in target list behavior WRT aggregates

2003-01-24 Thread Tom Lane
"Mike Mascari" <[EMAIL PROTECTED]> writes: > Hello. I have some code which generates subselects in the target > list of a query and then aggregates the results. The code allows > the user to determine the attributes of the aggregation. If the > user chooses to aggregate on the same value twice, I g

[HACKERS] Odd subselect in target list behavior WRT aggregates

2003-01-23 Thread Mike Mascari
Hello. I have some code which generates subselects in the target list of a query and then aggregates the results. The code allows the user to determine the attributes of the aggregation. If the user chooses to aggregate on the same value twice, I get the "Sub-SELECT" error. If the user chooses a di