I noticed this really inefficient query when QGIS was importing a Postgis
layer:
*select distinct case when geometrytype("the_geom") IN
('POINT','MULTIPOINT') THEN 'POINT' when geometrytype("the_geom") IN
('LINESTRING','MULTILINESTRING') THEN 'LINESTRING' when
geometrytype("the_geom") IN ('POLYGON','MULTIPOLYGON') THEN 'POLYGON' end
from [databaseGoesHere]*That surprised me because QGIS should already know the *geometrytype *through the *geomerty_columns* table. Is this really QGIS's fault, or did Postgis cause/require this? Want to make sure before I file a bug report. Thanks, Aren
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
