Slightly confused error message
| От | Markus Schaber |
|---|---|
| Тема | Slightly confused error message |
| Дата | |
| Msg-id | 44523BF1.1080307@logix-tt.com обсуждение исходный текст |
| Ответы |
Re: Slightly confused error message
|
| Список | 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 по дате отправления: