[postgis-users] possible bug: function st_asgeojson(geometry) is not unique

Tom van Tilburg tom.van.tilburg at gmail.com
Tue Jul 10 02:35:20 PDT 2012


In my opinion this should work:

         SELECT ST_AsGeoJson(ST_MakePoint(1,2))
or:   SELECT ST_AsGeoJson(ST_MakePoint(1,2)::geometry)

however, it produces:
--------------
ERROR:  function st_asgeojson(geometry) is not unique
LINE 1: SELECT ST_AsGeoJson(ST_MakePoint(1,2))
                ^
HINT:  Could not choose a best candidate function. You might need to add 
explicit type casts.
--------------

This does work:
     SELECT ST_AsGeoJson(ST_MakePoint(1,2),0,0)

My postgis version:
"POSTGIS="2.0.1 r9979" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel. 4.8.0, 6 March 
2012" GDAL="GDAL 1.9.1, released 2012/05/15" LIBXML="2.7.8" TOPOLOGY RASTER"



More information about the postgis-users mailing list