Re: Group By Error Text

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 Berkus
Aglio Database Solutions
San Francisco