Hi fellows, I had a ver nice reverse geocode function on my postgis 1.5.1 box.
When I install it to my new 1.5.2 postgis installation I get this.... ERROR: no existe el tipo «geometry» Which in english means type does not exist ?? huh ?? How, why ?? This is a piece of my function code *CREATE OR REPLACE FUNCTION fn.reversegeo (IN x numeric, IN y numeric, IN epsg integer DEFAULT 4326)* * RETURNS TABLE(.....)* * **DECLARE* * **x ALIAS FOR $1; y ALIAS FOR $2;** **epsg ALIAS FOR $3;* * **new_geo geometry;* Why when creating the function postgres tells me geometry type does not exist ? I tried both small and Capital cases. BTW config is: postgresql 9.0 with postgis 1.5.2 from the stack builder on my winxp box. PostGIS_Full_Version() : "POSTGIS="1.5.2" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.6.1, 21 August 2008" LIBXML="2.7.6" USE_STATS" Thanks in advanced, Ricardo
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
