Re: Syntax bug? Group by?

> 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.