1
linesubstring - using both segments
2
:memory: #use in-memory database
3
SELECT AsText(Line_Substring(GeomFromText("LINESTRING(0 0, 10 0, 10 10)"), 0.2, 0.8))
4
1 # rows (not including the header row)
6
AsText(Line_Substring(GeomFromText("LINESTRING(0 0, 10 0, 10 10)"), 0.2, 0.8))
7
LINESTRING(4 0, 10 0, 10 6)