Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7E502475E30
	for <pgsql-sql@postgresql.org>; Sun, 19 Jan 2003 17:40:12 -0500 (EST)
Received: from cumulus.netspace.net.au (cumulus.netspace.net.au
	[203.10.110.72])
	by postgresql.org (Postfix) with ESMTP id 79849475DBD
	for <pgsql-sql@postgresql.org>; Sun, 19 Jan 2003 17:40:10 -0500 (EST)
Received: from hollowcore.com.au (dialup-a3-75.Melbourne.netspace.net.au
	[203.113.250.75])
	by cumulus.netspace.net.au (8.12.6/8.12.6) with ESMTP id h0JMe626064414
	for <pgsql-sql@postgresql.org>; Mon, 20 Jan 2003 09:40:10 +1100 (EST)
	(envelope-from josephhh@hollowcore.com.au)
Received: from localhost (database.hollowcore.com.au [127.0.0.1])
	by hollowcore.com.au (Postfix) with ESMTP id F1E8C16FEF
	for <pgsql-sql@postgresql.org>; Mon, 20 Jan 2003 09:37:15 +1100 (EST)
Received: from joe.hollowcore.com.au (joe.hollowcore.com.au [192.168.1.112])
	by hollowcore.com.au (Postfix) with ESMTP id CC6BB16FEB
	for <pgsql-sql@postgresql.org>; Mon, 20 Jan 2003 09:36:48 +1100 (EST)
Received: by joe.hollowcore.com.au (Postfix, from userid 503)
	id ED770163AB; Sun, 19 Jan 2003 17:36:41 -0500 (EST)
Date: Mon, 20 Jan 2003 09:36:41 +1100
From: Joseph Healy <j.healy@ugrad.unimelb.edu.au>
To: pgsql-sql@postgresql.org
Subject: Group By Error Text
Message-ID: <20030119223641.GA1999@joe.hollowcore.com.au>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.4i
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/290
X-Sequence-Number: 11155

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