Grazzie mile Giuseppe! In fact, I can put everything inside the SELECT.
Alexandre Neto On Wed, Feb 6, 2013 at 12:54 PM, Giuseppe Sucameli <[email protected]>wrote: > Hi Alexandre, > > On Wed, Feb 6, 2013 at 1:42 PM, Alexandre Neto <[email protected]> > wrote: > > In DBManager SQLWindow [...] > > when I try to load it QGIS Canvas (selecting the Id and geometry > columns), I > > got the following error in the postgis warning tab: > > > > Erroneous query: SELECT * FROM "(WITH query_1 as ( > > unfortunately the provider doesn't support to load that statement, > it allows SELECT only. > > Anyway, until it is fixed, you could embed your WITH within a SELECT > statement. > > Regards. > > > SELECT * > > FROM ""PDM"".pdm_compare) > > SELECT * > > FROM query_1 > > )" LIMIT 1 returned 7 [ERROR: relation "(WITH query_1 as ( > > SELECT * > > FROM "PDM".pdm_compare) > > SELECT * > > " does not exist > > LINE 1: SELECT * FROM "(WITH query_1 as ( > > ^ > > ] > > > > I tried using qgis 1.9 and I was able to load the query. Is this a known > > problem in 1.8? Is there a workaround so I can use WITH statements in > QGIS > > 1.8. > > > > Thanks, > > > > Alexandre Neto > > > > _______________________________________________ > > Qgis-user mailing list > > [email protected] > > http://lists.osgeo.org/mailman/listinfo/qgis-user > > > > > > -- > Giuseppe Sucameli >
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
