Re: [HACKERS] 6.4 Aggregate Bug

Edmund Mergl wrote:

> David Hartwig wrote:
> >
> > While testing my 6.4 patch to allow functions/expressions to be
> > specified in the ORDER/GROUP BY clause (and not in the target list) I
>
> will this patch allow the following syntax :
>
> select count(SUBSTR(var,1,5)), SUBSTR(var,1,5) from t group by SUBSTR(var,1,5);
>
> This is important for writing database-independent code (e.g. it's the only
> syntax Oracle understands).
>
>

YES. It also handles expressions like "x / 2". Also, the functions (or
expressions) need not be in the target list.