Syntax bug? Group by? - Mailing list pgsql-hackers

From Mark Woodward
Subject Syntax bug? Group by?
Date
Msg-id 18370.24.91.171.78.1161099298.squirrel@mail.mohawksoft.com
Whole thread Raw
Responses Re: Syntax bug? Group by?  (Stephen Frost <sfrost@snowman.net>)
Re: Syntax bug? Group by?  (Markus Schaber <schabi@logix-tt.com>)
Re: Syntax bug? Group by?  (Peter Eisentraut <peter_e@gmx.net>)
Re: Syntax bug? Group by?  ("Przemek " <krycek6@wp.pl>)
List pgsql-hackers
Shouldn't this work?

select ycis_id, min(tindex), avg(tindex) from y where ycis_id = 15;

ERROR:  column "y.ycis_id" must appear in the GROUP BY clause or be used
in an aggregate function

If I am asking for a specific column value, should I, technically
speaking, need to group by that column?


pgsql-hackers by date:

Previous
From: HS
Date:
Subject: hacking postgres hashjoin algorithm
Next
From: Martijn van Oosterhout
Date:
Subject: Re: hacking postgres hashjoin algorithm