Pietro Rossin wrote > Which query builder? the one that is on the add postgis vector data? With > that I can only select item from a table, not execute query on geometry > column, right? > > Thankyou all > Pietro
In Layer properties / query, you can use whatever SQL you want if it is understood by Postgis and it is only a where clause. I often use subqueries that way: Let's assume your table has a my_id field , you want to filter geometry objects bases on postgis functions. You can sub filter object whith such a clause in query builder: my_id in (select distinct my_id from mytable where st_xmin(the_geom) >= 2317035 and st_xmax(the_geom) <= 2330326 ) I even could use very complex recursive queries that way.. No Limit... Just on of the greatest aspects of using spatialdatabases with QGIS... -- View this message in context: http://osgeo-org.1560.n6.nabble.com/load-data-in-Qgis-by-a-query-on-geom-column-tp5011161p5011517.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
