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

2013-08-01 Thread Giuseppe Sucameli
Hi Gis Mage, On Thu, Aug 1, 2013 at 12:38 AM, Gis Mage wrote: > Erroneous query: [...] 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

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

2013-07-31 Thread 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','MULT