Group By Error Text

From: Joseph Healy <j(dot)healy(at)ugrad(dot)unimelb(dot)edu(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: Group By Error Text
Date: 2003-01-19 22:36:41
Message-ID: 20030119223641.GA1999@joe.hollowcore.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2003-01-19 22:46:39 Re: Group By Error Text
Previous Message Josh Berkus 2003-01-19 22:34:21 Re: Selecting a non-locked row.