> Hi, Mark, > > Mark Woodward wrote: >> 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? > > Try: > > SELECT 15 as ycis_id, min(tindex), avt(tindex) from y where ycis_id = 15; > > This isn't a "SQL" question!!! This is a question of whether or not PostgreSQL is correct in requiring a "group by" in the query. I assert that since it is unabiguous as to what "ycis_id" should be, PostgreSQL should not require a grouping.
---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly