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
This would require a great deal of special-casing, in particular knowledge of the = operator, and then the restriction to a particular form of the WHERE clause. For overall consistency, I don't think this should be allowed. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
