1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
scale coords - POLYGONZM with inner ring
:memory: #use in-memory database
SELECT AsText(ScaleCoords(geom, 0)), AsText(ScaleCoords(geom, 0.0)), AsText(ScaleCoords(geom, 2, 3.0)), AsText(ScaleCoords(geom, 1.0, -1)), ScaleCoords(zeroblob(20), 10), ScaleCoords(geom, 'hello'), ScaleCoords(geom, 1, 'hello'), ScaleCoords('foo', 2) FROM (SELECT GeomFromText('POLYGONZM((0 0 1 2, 0 4 1 2, 4 4 1 2, 4 0 1 2, 0 0 1 2),(1 2 1 2, 1 3 1 2, 2 3 1 2, 2 2 1 2, 1 2 1 2))') as geom) dummy;
1 # rows (not including the header row)
8 # columns
AsText(ScaleCoords(geom, 0))
AsText(ScaleCoords(geom, 0.0))
AsText(ScaleCoords(geom, 2, 3.0))
AsText(ScaleCoords(geom, 1.0, -1))
ScaleCoords(zeroblob(20), 10)
ScaleCoords(geom, 'hello')
ScaleCoords(geom, 1, 'hello')
ScaleCoords('foo', 2)
POLYGON ZM((0 0 1 2, 0 0 1 2, 0 0 1 2, 0 0 1 2, 0 0 1 2), (0 0 1 2, 0 0 1 2, 0 0 1 2, 0 0 1 2, 0 0 1 2))
POLYGON ZM((0 0 1 2, 0 0 1 2, 0 0 1 2, 0 0 1 2, 0 0 1 2), (0 0 1 2, 0 0 1 2, 0 0 1 2, 0 0 1 2, 0 0 1 2))
POLYGON ZM((0 0 1 2, 0 12 1 2, 8 12 1 2, 8 0 1 2, 0 0 1 2), (2 6 1 2, 2 9 1 2, 4 9 1 2, 4 6 1 2, 2 6 1 2))
POLYGON ZM((0 0 1 2, 0 -4 1 2, 4 -4 1 2, 4 0 1 2, 0 0 1 2), (1 -2 1 2, 1 -3 1 2, 2 -3 1 2, 2 -2 1 2, 1 -2 1 2))
(NULL)
(NULL)
(NULL)
(NULL)
|
