1
ShortestLine - line and point
2
:memory: #use in-memory database
3
SELECT AsText(ShortestLine(GeomFromText("LINESTRING(0 0, 10 0)"), GeomFromText("POINT(0 2)")))
4
1 # rows (not including the header row)
6
AsText(ShortestLine(GeomFromText("LINESTRING(0 0, 10 0)"), GeomFromText("POINT(0 2)")))