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;
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
