Slightly confused error message - Mailing list pgsql-sql

From Markus Schaber
Subject Slightly confused error message
Date
Msg-id 44523BF1.1080307@logix-tt.com
Whole thread Raw
Responses Re: Slightly confused error message  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Hi,

I just stumbled over a slightly confused error message:

mydb=# select count(*),coverage_area from myschema.streets except select
cd as coverage_area from countryref.disks group by streets.coverage_area;
ERROR:  column "streets.coverage_area" must appear in the GROUP BY
clause or be used in an aggregate function

As the query looks, streets.coverage_area is actually used in the GROUP BY.

I know how to fix the query, but I wonder whether it is worth the effort
to try improving the error message.

Thanks,
Markus
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org


pgsql-sql by date:

Previous
From: Guy Fraser
Date:
Subject: Re: LinkedList
Next
From: Tom Lane
Date:
Subject: Re: Slightly confused error message