Skip to content
🎉 Apache Sedona 1.8.1 is now available! Check out the new features and improvements.

ST_RemovePoint

Introduction: Return Linestring with removed point at given index, position can be omitted and then last one will be removed.

Format:

ST_RemovePoint(geom: Geometry, position: Integer)

ST_RemovePoint(geom: Geometry)

Since: v1.3.0

Example:

SELECT ST_RemovePoint(ST_GeomFromText("LINESTRING(0 0, 1 1, 1 0)"), 1)

Output:

LINESTRING(0 0, 1 0)