ST_Scroll — 更改闭合线串的起点。
geometry ST_Scroll(geometry linestring, geometry point);
geometry ST_Scroll(
)
将闭合线串的起点/终点更改为给定顶点 点 。
点
可用性:3.2.0
This function supports 3d and will not drop the z-index.
This function supports M coordinates.
使闭合直线从其第三个顶点开始
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)
ST_Normalize