ST_SetPoint

Replace Nth point of linestring with given point. Index is 0-based. Negative index are counted backwards, e.g., -1 is last point.

Signatures

ST_SetPoint (linestring: Geometry, index: Integer, point: Geometry)

linestring

Geometry

required

The linestring value.

index

Integer

required

The index value.

point

Geometry

required

The point value.

The resulting geometry.

SELECT ST_SetPoint(ST_GeomFromText('LINESTRING (0 0, 0 1, 1 1)'), 2, ST_GeomFromText('POINT (1 0)'))

LINESTRING (0 0, 0 1, 1 0)

⌘I