What does SELECT 'POINT(0 0)'::geometry;
return? On Fri, Oct 8, 2010 at 12:12 PM, Ricardo Bayley <[email protected]> wrote: > 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 > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
