[postgis-users] ST_Polygonize thows an error

[Francois Hugues]

Hello,

This error seems normal to me : in your sub select cntr_value is aliased as the_geom but does not seem to be of geometry type. If it is really a value, double precision should be correct and st_polygonize is waiting for a geometry.

Hugues.


-------- Message d'origine--------
De: postgis-users-bounces at lists.osgeo.org de la part de Jeff Lake
Date: mer. 12/12/2012 20:48
À: PostGIS Users Discussion
Objet : [postgis-users] ST_Polygonize thows an error
 
I using the following query

SELECT ST_Polygonize(the_geom) FROM (SELECT 
ST_AsTEXT(the_geom),date,cntr_value AS the_geom FROM li_poly_000 ORDER 
BY cntr_value desc) as foo;

the Error:

ERROR:  function st_polygonize(double precision) does not exist
LINE 1: select ST_Polygonize(the_geom) from (select st_astext(the_ge...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.


PostGisFullVersion();

POSTGIS="2.0.1 r9979" GEOS="3.3.6-CAPI-1.7.6" PROJ="Rel. 4.8.0, 6 March 2012" LIBXML="2.7.6"






-- 
*Jeff Lake*
MichiganWxSystem <http://www.michiganwxsystem.com>
AllisonHouse <http://www.allisonhouse.com>
GRLevelXStuff <http://www.grlevelxstuff.com>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 3313 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121212/e18993aa/attachment.bin>