Re: grouping by expressions

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.

thanks,
.greg