[postgis-users] Using cleangeometry() on only the Multipolygons in a field of type geometry

[strk]

On Mon, Jan 24, 2011 at 09:35:52PM -0500, Pete Yunker wrote:
> We have a field of type geometry containing both Multipolygon and Point entities.  How can cleangeometry be used on only the Multipolygons, since cleangeometry cannot be used on a field of type geometry?
> 
> The following query fails with "ERROR:  function cleangeometry(geometry) does not exist"
..
> 1.3.6 PostGIS
> 3.1.0 GEOS

cleangeometry is a contributed procedure.

PostGIS itself has an ST_MakeValid, which does a similar thing, but
only starting with version 2.0.0 (available trough the source
repository, but not released yet).

You might have missed to install the contributed procedure, which I guess
you found on the PostGIS wiki.

--strk; 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html