>
>    select func(x), aggfunc(y) group by func
>        CRASHES
>

I think this should be disallowed syntax. Note that func is a system generated label 
in this case, that's probably why the parser does not complain. The syntax has to be:

select func(x), aggfunc(y) group by func(x);  -- or

select func(x) as func, aggfunc(y) group by func;

Andreas


Mon, 24 Aug 1998 15:00:51 +0200
Andreas Zeugswetter <andreas.zeugswetter@telecom.at>
AW: [HACKERS] 6.4 Aggregate Bug


Andreas Zeugswetter wrote:

> >
> >    select func(x), aggfunc(y) group by func
> >        CRASHES
> >
>
> I think this should be disallowed syntax. Note that func is a system generated label
> in this case, that's probably why the parser does not complain. The syntax has to be:
>
> select func(x), aggfunc(y) group by func(x);  -- or
>
> select func(x) as func, aggfunc(y) group by func;
>

To my knowledge postgres has always allowed this syntax.  IMO is seems harmless to
continue.  In any case, all of these syntax permutations will crash the backend in using
6.4.


Mon, 24 Aug 1998 09:42:53 -0400
David Hartwig <daveh@insightdist.com>
Re: AW: [HACKERS] 6.4 Aggregate Bug