Name

ST_Scroll — Change start point of a closed LineString.

Synopsis

geometry ST_Scroll(geometry linestring, geometry point);

Descrizione

Changes the start/end point of a closed LineString to the given vertex point.

Disponibilità: 3.2.0

Questa funzione supporta il 3d e non distrugge gli z-index.

Questa funzione supporta le coordinate M.

Esempi

Make e closed line start at its 3rd vertex

SELECT ST_AsEWKT(ST_Scroll('SRID=4326;LINESTRING(0 0 0 1, 10 0 2 0, 5 5 4 2,0 0 0 1)', 'POINT(5 5 4 2)'));

st_asewkt
----------
SRID=4326;LINESTRING(5 5 4 2,0 0 0 1,10 0 2 0,5 5 4 2)

Si veda anche

ST_Normalize