1
2
3
4
5
6
7
|
reverse - GeometryCollection XY
:memory: #use in-memory database
SELECT AsEWKT(ST_Reverse(GeomFromText('GEOMETRYCOLLECTION(POINT(1 2), LINESTRING(3 4, 5 6, 7 8, 9 9), POLYGON((10 10, 15 10, 13 13, 10 10), (11 10.5, 13 10.5, 13 11.3, 11 10.5)), POLYGON((20 20, 27 20, 22 18, 20 20), (21 19.5, 27 19.5, 22 18.5, 21 19.5)))')));
1 # rows (not including the header row)
1 # columns
AsEWKT(ST_Reverse(GeomFromText('GEOMETRYCOLLECTION(POINT(1 2), LINESTRING(3 4, 5 6, 7 8, 9 9), POLYGON((10 10, 15 10, 13 13, 10 10), (11 10.5, 13 10.5, 13 11.3, 11 10.5)), POLYGON((20 20, 27 20, 22 18, 20 20), (21 19.5, 27 19.5, 22 18.5, 21 19.5)))')))
SRID=0;GEOMETRYCOLLECTION(POINT(1 2),LINESTRING(9 9,7 8,5 6,3 4),POLYGON((10 10,13 13,15 10,10 10),(11 10.5,13 11.3,13 10.5,11 10.5)),POLYGON((20 20,22 18,27 20,20 20),(21 19.5,22 18.5,27 19.5,21 19.5)))
|
