[postgis-users] 1.5.2 Issue

[Paul Ramsey]

What does

SELECT 'POINT(0 0)'::geometry;

return?

On Fri, Oct 8, 2010 at 12:12 PM, Ricardo Bayley
<ricardo.bayley at gmail.com> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>