Skip to main content
RETURN Line with removed point at given index, position can be omitted and then last one will be removed. ST_RemovePoint

​
Signatures

ST_RemovePoint(geom: Geometry, position: Integer)

ST_RemovePoint(geom: Geometry)

​
Parameters

​
geom
Geometry
required
The input geometry.
​
position
Integer
The position value.

​
Return type

The resulting geometry.

​
Example

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

LINESTRING(0 0, 1 0)