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: [email protected] 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>
<<winmail.dat>>
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
