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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
|
BEGIN;
BEGIN
SET client_min_messages TO NOTICE;
SET
CREATE TABLE maptest as
SELECT 671222::integer as id, 318255::integer as source, 222698::integer as target, 14.02::float8 as cost, 14.02::float8 as reverse_cost UNION ALL
SELECT 671223, 222698, 36655, 197.16, 197.16 UNION ALL
SELECT 582877, 408918, 5556, 458.09, 458.09 UNION ALL
SELECT 582876, 318255, 408918, 3.89, 3.89 UNION ALL
SELECT 585280, 5556, 454424, 54.84, 54.84;
SELECT 5
SELECT seq, id1 AS node, id2 AS edge, cost::numeric(11,4)
FROM pgr_trsp(
'select * from maptest',
582877,
0,
582877,
0.5,
true,
true,
null
) PG ;
WARNING: pgr_trsp(text,integer,float,integer,float,boolean,boolean) deprecated on v3.4.0
seq | node | edge | cost
-----+--------+--------+----------
0 | 408918 | 582877 | 229.0450
1 | -2 | -1 | 0.0000
(2 rows)
SELECT seq, id1 AS node, id2 AS edge, cost::numeric(11,4)
FROM pgr_trsp(
'select * from maptest',
582877,
0.0000000001,
582877,
0.5,
true,
true,
null
) PG ;
WARNING: pgr_trsp(text,integer,float,integer,float,boolean,boolean) deprecated on v3.4.0
seq | node | edge | cost
-----+------+--------+----------
0 | -1 | 582877 | 229.0450
1 | -2 | -1 | 0.0000
(2 rows)
SELECT seq, id1 AS node, id2 AS edge, cost::numeric(11,4)
FROM pgr_trsp(
'select * from maptest',
582877,
0,
582877,
0.5,
true,
true,
$$SELECT 100::float AS to_cost, 25::INTEGER AS target_id, '32, 33'::TEXT AS via_path$$
) PG ;
WARNING: pgr_trsp(text,integer,float,integer,float,boolean,boolean) deprecated on v3.4.0
seq | node | edge | cost
-----+------+--------+----------
0 | -1 | 582877 | 229.0450
(1 row)
SELECT seq, id1 AS node, id2 AS edge, cost::numeric(11,4)
FROM pgr_trsp(
'select * from maptest',
582877,
0.0000000001,
582877,
0.5,
true,
true,
$$SELECT 100::float AS to_cost, 25::INTEGER AS target_id, '32, 33'::TEXT AS via_path$$
) PG ;
WARNING: pgr_trsp(text,integer,float,integer,float,boolean,boolean) deprecated on v3.4.0
seq | node | edge | cost
-----+------+--------+----------
0 | -1 | 582877 | 229.0450
(1 row)
SELECT seq, id1 AS node, id2 AS edge, cost::numeric(11,4)
FROM pgr_trsp(
'select * from maptest',
582877,
0,
582877,
1,
true,
true
);
WARNING: pgr_trsp(text,integer,float,integer,float,boolean,boolean) deprecated on v3.4.0
seq | node | edge | cost
-----+--------+--------+----------
0 | 408918 | 582877 | 458.0900
1 | 5556 | -1 | 0.0000
(2 rows)
ROLLBACK;
ROLLBACK
|
