[Qgis-developer] DB Manager changing behaviour?

Paolo Cavallini cavallini at faunalia.it
Fri Aug 28 00:12:14 PDT 2015


Hi all,
currently, DB Manager throws an error for a query like this:

SELECT aaa, ST_Area(geom) AS bbb
 FROM ccc
 ORDER BY bbb

requiring instead:

SELECT aaa, ST_Area(geom) AS "bbb"
FROM ccc
ORDER BY bbb

This is correct, but annoying, and breaks previous queries. Is the
change really necessary? Wouldn't it be better to revert it?

Thanks.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html


More information about the Qgis-developer mailing list