Re: Group By Error Text

Поиск
Список
Период
Сортировка
Искать

Re: Group By Error Text

От:
Josh Berkus <josh@agliodbs.com>
Дата:

Joe,

> ERROR:  Attribute drawing_register.jobno must be GROUPed or used in an
> aggregate function
> 
> Is this correct? Getting rid of the error is easy:
> 
> select jobno, count(jobno) from drawing_register group by jobno;
> 
> I believe that jobno is being used in an aggregate function. Should a
> change be made to the error text?

Nope.  The error message is exactly correct.   If you didn't want to GROUP BY 
jobno, then what you actually wanted to query was:

SELECT count(jobno) FROM drawing_register;

-- 
-Josh BerkusAglio Database SolutionsSan Francisco

Group By Error Text

От:
Joseph Healy <j.healy@ugrad.unimelb.edu.au>
Дата:
Hi

with the following query:

select jobno, count(jobno) from drawing_register;

I get the following error:

ERROR:  Attribute drawing_register.jobno must be GROUPed or used in an
aggregate function

Is this correct? Getting rid of the error is easy:

select jobno, count(jobno) from drawing_register group by jobno;

I believe that jobno is being used in an aggregate function. Should a
change be made to the error text?

Regards


Joe Healy
FAQ