Re: grouping by expressions

On 3 Nov 2010, at 02:42, Gregory Williams <greg@evilfunhouse.com> wrote:

> On Nov 2, 2010, at 5:06 PM, Lee Feigenbaum wrote:
> 
>> I believe there are likely three options:
>> 
>> 1) To project grouping expressions, use BIND to alias the expression to a variable and then GROUP BY and project that variable (as above).
>> 
>> 2) Include an AS aliasing mechanism in GROUP BY, allow that alias to be projected in the SELECT clause
>> 
>> 3) Allow SELECT list aliases to be used in the GROUP BY expression
>> 
>> Can people please indicate on the mailing list which direction they'd like us to go on this, and we will then wrap this up on next Tuesday's telecon?
> 
> 3 seems backwards to me -- not really sure how it would work. I currently implement 2 and am happy with it, but 1 would seem to be reasonable also.

Agreed that 3 seems odd.

Preference for 1 as were going to have that mechanism anyway. Allowing AS in GROUP BY as well seems excessive, and will further complicate the algebra in that area. 

- Steve

Received on Wednesday, 3 November 2010 07:12:35 UTC