AW: [HACKERS] 6.4 Aggregate Bug

From: Andreas Zeugswetter <andreas(dot)zeugswetter(at)telecom(dot)at>
To: "'hackers(at)postgresql(dot)org'" <hackers(at)postgresql(dot)org>
Subject: AW: [HACKERS] 6.4 Aggregate Bug
Date: 1998-08-24 13:00:51
Message-ID: 01BDCF70.C1032EE0@zeugswettera.user.lan.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Hartwig 1998-08-24 13:42:53 Re: AW: [HACKERS] 6.4 Aggregate Bug
Previous Message Andreas Zeugswetter 1998-08-24 12:54:08 USE_LOCALE and unsigned char *