Group By Error Text - Mailing list pgsql-sql

From Joseph Healy
Subject Group By Error Text
Date
Msg-id 20030119223641.GA1999@joe.hollowcore.com.au
Whole thread Raw
Responses Re: Group By Error Text
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Selecting a non-locked row.
Next
From: Josh Berkus
Date:
Subject: Re: Group By Error Text