1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
rotate coords - PointZ
:memory: #use in-memory database
SELECT AsText(RotateCoords(geom, 0)), AsText(RotateCoords(geom, 90.0)), AsText(RotateCoords(geom, 180.0)), AsText(RotateCoords(geom, -90)), RotateCoords(zeroblob(20), 10), RotateCoords(geom, 'hello'), RotateCoords('foo', 30) FROM (SELECT GeomFromText('POINTZ(1 2 1.5)') as geom) dummy;
1 # rows (not including the header row)
7 # columns
AsText(RotateCoords(geom, 0))
AsText(RotateCoords(geom, 90.0))
AsText(RotateCoords(geom, 180.0))
AsText(RotateCoords(geom, -90))
RotateCoords(zeroblob(20), 10)
RotateCoords(geom, 'hello')
RotateCoords('foo', 30)
POINT Z(1 2 1.5)
POINT Z(2 -1 1.5)
POINT Z(-1 -2 1.5)
POINT Z(-2 1 1.5)
(NULL)
(NULL)
(NULL)
|
