1
2
3
4
5
6
7
|
Geometry N - multipolygonM
:memory: #use in-memory database
SELECT AsText(GeometryN(GeomFromText('MULTIPOLYGONM(((0 0 1, 10 0 1, 10 10 1, 0 10 1, 0 0 1),(2 2 2, 8 2 2, 8 8 2, 2 8 2, 2 2 2)),((0 0 3, -10 0 3, -10 -10 3, 0 -10 3, 0 0 3)))'), 1))
1 # rows (not including the header row)
1 # columns
AsText(GeometryN(GeomFromText('MULTIPOLYGONM(((0 0 1, 10 0 1, 10 10 1, 0 10 1, 0 0 1),(2 2 2, 8 2 2, 8 8 2, 2 8 2, 2 2 2)),((0 0 3, -10 0 3, -10 -10 3, 0 -10 3, 0 0 3)))'), 1))
POLYGON M((0 0 1, 10 0 1, 10 10 1, 0 10 1, 0 0 1), (2 2 2, 8 2 2, 8 8 2, 2 8 2, 2 2 2))
|
