Markus Schaber <[EMAIL PROTECTED]> writes:
> 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.
I'm not sure about localizing the subquery per se, but it might be
possible to add a syntax pointer to the
On Fri, 28 Apr 2006 12:07:04 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> Markus Schaber <[EMAIL PROTECTED]> writes:
>> 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.disk
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
Markus Schaber <[EMAIL PROTECTED]> writes:
> 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
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
