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

From Andreas Zeugswetter
Subject AW: [HACKERS] 6.4 Aggregate Bug
Date
Msg-id 01BDCF70.C1032EE0@zeugswettera.user.lan.at
Whole thread Raw
List pgsql-hackers
>
>    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


pgsql-hackers by date:

Previous
From: Andreas Zeugswetter
Date:
Subject: USE_LOCALE and unsigned char *
Next
From: David Hartwig
Date:
Subject: Re: [HACKERS] Regression test status (was type coersion)