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
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