Re: AW: [HACKERS] 6.4 Aggregate Bug - Mailing list pgsql-hackers

From David Hartwig
Subject Re: AW: [HACKERS] 6.4 Aggregate Bug
Date
Msg-id 35E16DDD.AE987DC0@insightdist.com
Whole thread Raw
In response to AW: [HACKERS] 6.4 Aggregate Bug  (Andreas Zeugswetter <andreas.zeugswetter@telecom.at>)
List pgsql-hackers

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.


pgsql-hackers by date:

Previous
From: David Hartwig
Date:
Subject: Re: [HACKERS] Regression test status (was type coersion)
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] Re: [HACKERS] Convert PGconn, PGresult to opaque types?