ST_SharedPaths — 返回一个集合，其中包含两个输入线串/多线串共享的路径。
geometry ST_SharedPaths(geometry lineal1, geometry lineal2);
返回一个集合，其中包含两个输入几何图形共享的路径。 那些朝相同方向去的在集合的第一个元素中，那些朝相反方向去的在第二个元素中。 路径本身是在第一个几何体的方向上给出的。
这个函数是由 GEOS 模块执行的。
可用性: 2.0.0
Adjacent shared path segments may be returned as separate or merged LineStrings depending on the GEOS version.
Find the shared paths of a MultiLineString and a LineString.
SELECT ST_SharedPaths(ST_GeomFromText('MULTILINESTRING((26 125,26 200,126 200,126 125,26 125),
(51 150,101 150,76 175,51 150))'),
ST_GeomFromText('LINESTRING(151 100,126 156.25,126 125,101 150,76 175)')
)
GEOMETRYCOLLECTION(MULTILINESTRING((126 156.25,126 125), (101 150,76 175)),MULTILINESTRING EMPTY)
0107000000020000000105000000020000000102000000020000000000000000805F4000000000008863400000000000805F400000000000405F4001020000000200000000000000004059400000000000C0624000000000000053400000000000E06540010500000000000000
Flip the LineString orientation to return the same paths in the opposite-direction member.
SELECT ST_SharedPaths(ST_GeomFromText('LINESTRING(76 175,101 150,126 125,126 156.25,151 100)'),
ST_GeomFromText('MULTILINESTRING((26 125,26 200,126 200,126 125,26 125),
(51 150,101 150,76 175,51 150))')
)
GEOMETRYCOLLECTION(MULTILINESTRING EMPTY, MULTILINESTRING((76 175,101 150),(126 125,126 156.25)))
01070000000200000001050000000000000001050000000200000001020000000200000000000000000053400000000000E0654000000000004059400000000000C062400102000000020000000000000000805F400000000000405F400000000000805F400000000000886340