[Qgis-user] DB Manager

[ALT SHN]

Hi list,

I've been struggling with DB Manager, and I hope someone can explain me
what the problem is.

I am querying a PostGIS table but when I try to load the SELECT results to
map canvas nothing happens! A simple example:

SELECT * FROM FREGUESIAS_2013 where freguesia ILIKE 'a%'

returns thos message in log winfow:

*Erroneous query: SELECT DISTINCT CASE WHEN
upper(geometrytype("area_ea_ha")) IN
('POINT','MULTIPOINT','POINTM','MULTIPOINTM') THEN 'POINT' WHEN
upper(geometrytype("area_ea_ha")) IN
('LINESTRING','MULTILINESTRING','LINESTRINGM','MULTILINESTRINGM') THEN
'LINESTRING' WHEN upper(geometrytype("area_ea_ha")) IN
('POLYGON','MULTIPOLYGON','POLYGONM','MULTIPOLYGONM') THEN 'POLYGON' END,
st_srid("area_ea_ha") FROM (SELECT *, geom::geometry FROM FREGUESIAS_2013
where freguesia ILIKE 'a%'*
*) AS "subQuery_0" returned 7 [ERROR:  function geometrytype(double
precision) does not exist*
*LINE 1: SELECT DISTINCT CASE WHEN upper(geometrytype("area_ea_ha")) ...*
*                                        ^*
*HINT:  No function matches the given name and argument types. You might
need to add explicit type casts.*
*]*

Now the strange think is that if use this query as a CREATE VIEW, the view
can be added to map canvas! Any hints?

Thanks in advance,

André

-- 
---------------------------------------------------------------


*Sociedade de História Natural*
Departamento de Informação Geográfica
Polígono Industrial do Alto do Amial
Pav.H02 e H06

i.geografica at alt-shn.org <laboratorio at alt-shn.org>
www.shn.pt
www.alt-shn.blogspot.com
Facebook <https://www.facebook.com/SociedadeDeHistoriaNatural?ref=hl>

TLM: 964138188
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20140202/be8480d8/attachment.html>