[Qgis-user] PostGIS query running in 1.7.4 but not 1.9

[Salvatore Larosa]

Il giorno ven, 27/04/2012 alle 10.28 +0100, James Stott ha scritto:
> I am trying to run a query in QGIS. The query below works in QGIS 1.7.4
> but I cannot get it to open in 1.9 (Windows 7).
> 
> SELECT "units"."gid", "units"."name", "pipe"."section",
> "units"."the_geom"
> FROM "data"."units", "data"." pipe" 
> WHERE " pipe"."section" = 'W' and ST_DWithin("pipe"."the_geom",
> "units"."the_geom", 500);
> 
> Does anyone know what I am doing wrong?

Hi James,
I see a blank space in name table (pipe) in clause FROM:

FROM "data"."units", "data"." pipe" 

Could be the problem there?

Regards,

-SL