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
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
