On Fri, Dec 02, 2005 at 11:24:10PM -0500, Igor Tandetnik wrote:
> It is indeed an illegal SQL query. You probably want
>
> select id from test
> group by id
> having avg(rating) > 10;
I hadn't realized that my query was actually illegal. OK.
> >The workaround of putting the aggregate in a
Nathan Kurz <[EMAIL PROTECTED]> wrote:
I was just about to file a bug about a segfault when I have an
aggregate in the where clause like:
select id from test where avg(rating) > 10 group by id;
But when I looked in the bug reports, I found that several similar
bugs had been reported and that
2 matches
Mail list logo