제목
ST_Scroll — Change start point of a closed LineString.
요약
geometry ST_Scroll(geometry linestring, geometry point);
설명
Changes the start/end point of a closed LineString to the given vertex point.
Availability: 3.2.0
This function supports 3d and will not drop the z-index.
This function supports M coordinates.
예시
Make a closed line start at its 3rd vertex.
Code
SELECT 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)');
래스터 출력
SRID=4326;LINESTRING(5 5 4 2,0 0 0 1,10 0 2 0,5 5 4 2)
Figure