1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
\set VERBOSITY terse
set client_min_messages to WARNING;
SELECT topology.CreateTopology('2d') > 0;
SELECT topology.CreateTopology('2dAgain', -1, 0, false) > 0;
SELECT topology.CreateTopology('3d', -1, 0, true) > 0;
SELECT topology.CreateTopology('3d'); -- already exists
SELECT name,srid,precision,hasz from topology.topology
WHERE name in ('2d', '2dAgain', '3d' )
ORDER by name;
-- Only 3dZ accepted in 3d topo
SELECT topology.AddNode('3d', 'POINT(0 0)');
SELECT topology.AddNode('3d', 'POINTM(1 1 1)');
SELECT topology.AddNode('3d', 'POINT(2 2 2)');
-- Only 2d accepted in 2d topo
SELECT topology.AddNode('2d', 'POINTM(0 0 0)');
SELECT topology.AddNode('2d', 'POINT(1 1 1)');
SELECT topology.AddNode('2d', 'POINT(2 2)');
SELECT topology.DropTopology('2d');
SELECT topology.DropTopology('2dAgain');
SELECT topology.DropTopology('3d');
-- Exceptions
SELECT topology.CreateTopology('public');
SELECT topology.CreateTopology('topology');
|
