From: Markus Schaber <schabi@logix-tt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL SQL List <pgsql-sql@postgresql.org>
Subject: Re: Slightly confused error message
Date: Fri, 28 Apr 2006 18:30:08 +0200
Message-ID: <44524310.70906@logix-tt.com> (raw)
In-Reply-To: <1612.1146240424@sss.pgh.pa.us>
References: <44523BF1.1080307@logix-tt.com>
<1612.1146240424@sss.pgh.pa.us>
Hi, Tom,
Tom Lane wrote:
>>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.
>
> The complaint is 100% accurate;
I know that, and won't deny.
> the subquery that it's unhappy about is
>
> select count(*),coverage_area from myschema.streets
>
> which is an aggregating query, but coverage_area is being used outside
> an aggregate without having been grouped by.
Yes, and my question is whether it is easy and worth the effort. to add
that information (about the acutally offending subquery) to the 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: schabi@logix-tt.com, tgl@sss.pgh.pa.us
Subject: Re: Slightly confused error message
In-Reply-To: <44524310.70906@logix-tt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox