[Qgis-user] postgis sql query doesn't add as layer

[Gis Mage]

Hi list,
I'm running a simple sql query in DB Manager:

select 1 as gid, st_setsrid(st_makepoint(10,10),4326) as geo


Then I want to load it as a new layer and get an error in a console.


Erroneous query: SELECT DISTINCT CASE WHEN upper(geometrytype("geo")) IN
('POINT','MULTIPOINT','POINTM','MULTIPOINTM') THEN 'POINT' WHEN
upper(geometrytype("geo")) IN
('LINESTRING','MULTILINESTRING','LINESTRINGM','MULTILINESTRINGM') THEN
'LINESTRING' WHEN upper(geometrytype("geo")) IN
('POLYGON','MULTIPOLYGON','POLYGONM','MULTIPOLYGONM') THEN 'POLYGON' END,
st_srid("geo") FROM (SELECT "geo" FROM ""."(select 1 as gid,
st_setsrid(st_makepoint(10,10),4326) as geo

) AS ""subQuery_0""" WHERE "geo" IS NOT NULL LIMIT 100) AS t returned 7
[ERROR:  zero-length delimited identifier at or near """"

LINE 1: ...YGON' END, st_srid("geo") FROM (SELECT "geo" FROM ""."(selec...

                                                             ^

]



What's wrong with my query?

I'm running QGIS 1.8.0 on OS X
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130801/4395c878/attachment.html>