1
2
3
4
5
6
7
8
|
collect - Polygon, Polygon
:memory: #use in-memory database
SELECT AsText(COLLECT(GeomFromText('POLYGON((1 2, 3 4, 3 2, 1 2),(1.5 2.5, 2.5 3.5, 2.5 2.3, 1.5 2.5))'), GeomFromText('POLYGON((4 5, 1 2, 4 2, 4 5),(2 3, 3 4, 3 3, 2 3))')));
1 # rows (not including the header row)
1 # columns
AsText(COLLECT(GeomFromText('POLYGON((1 2, 3 4, 3 2, 1 2),(1.5 2.5, 2.5 3.5, 2.5 2.3, 1.5 2.5))'), GeomFromText('POLYGON((4 5, 1 2, 4 2, 4 5),(2 3, 3 4, 3 3, 2 3))')))
MULTIPOLYGON(((1 2, 3 4, 3 2, 1 2), (1.5 2.5, 2.5 3.5, 2.5 2.3, 1.5 2.5)), ((4 5, 1 2, 4 2, 4 5), (2 3, 3 4, 3 3, 2 3)))
|
