跳转至
Apache Sedona 1.9.0 已正式发布,新增 Spark 4.1 支持、proj4sedona 坐标系转换、Bing Tile 函数等众多特性!

ST_RemovePoint

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

ST_RemovePoint

Format:

ST_RemovePoint(geom: Geometry, position: Integer)

ST_RemovePoint(geom: Geometry)

Return type: Geometry

Since: v1.0.0

SQL Example

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

Output:

LINESTRING(0 0, 1 0)