Have a look at this: http://www.carsonfarmer.com/?p=713
and the RT Sql Layer plugin Carson On 30 September 2010 13:15, Ricardo Filipe Soares Garcia da <[email protected]> wrote: > Hi list > Some questions on building querys with spatialite and postgis: > > 1 - Is it possible to build a query where two (or more) layers are > involved? Something like: > > SELECT a.* > FROM a, b > WHERE Contains(b, a) > > and get a visual result in the main Qgis display? I know I can do such > a query using the spatialite manager, but the return value is > visualized only as tabular data. > > 2 - Is it possible to dynamically create new geometries? For example, > write a custom query that creates a buffer around a point and store it > in a temporary layer? > > >From what I have been investigating it seems that these things are not > possible. Am I wrong? This kind of functionality would be really > awesome. > > -- > ___________________________ ___ __ > Ricardo Garcia Silva > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user > -- Carson J. Q. Farmer ISSP Doctoral Fellow National Centre for Geocomputation National University of Ireland, Maynooth, http://www.carsonfarmer.com/ _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
