This topic describes the ST_RemoveRepeatedPoints function. This function deletes the duplicated points of the input geometry object and returns a new geometry object.

Syntax

geometry  ST_RemoveRepeatedPoints(geometry  geom , float8  tolerance);

Parameters

Parameter Description
geom The geometry object that you want to specify.
tolerance The tolerance that you want to specify.

Description

Results returned by using the default parameter settings:
select ST_AsText(ST_RemoveRepeatedPoints('POLYGON((0 0,1 0,1 0,1 1,0 0))'::geometry));
         st_astext
----------------------------
 POLYGON((0 0,1 0,1 1,0 0))
(1 row)