Super!! one more question I am training on making spatial queries with postgis/qgis. this query:
SELECT ST_Union(ST_Buffer(r.geom,1609*10)) As geom FROM ch01.roads As r WHERE r.name = 'US Route 1' AND r.state = 'MD'; that select a road based on its name and crossing state and perform a union of all the buffers deriving from its segments (it's a segmented road) doesn't load in Qgis. It works both in pgadmin and openjump. Qgis don't load the query result I think because it lacks of a unique id column, right? But in this case, how can I add a unique id field (volatile) to the query? Thankyou -- View this message in context: http://osgeo-org.1560.n6.nabble.com/load-data-in-Qgis-by-a-query-on-geom-column-tp5011161p5012233.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user