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
|
-- CopyRight(c) pgRouting developers
-- Creative Commons Attribution-Share Alike 3.0 License : https://creativecommons.org/licenses/by-sa/3.0/
UPDATE edges SET id = id * 100, source = 1000 * source, target = 1000 * target;
UPDATE vertices SET id = id * 1000;
SELECT id, source, target, cost, reverse_cost FROM edges;
SELECT id FROM vertices;
SELECT * FROM pgr_lineGraphFull(
$$SELECT id, source, target, cost FROM edges WHERE id = 1$$
);
SELECT * FROM pgr_lineGraphFull(
$$SELECT id, source, target, cost, reverse_cost
FROM edges
WHERE id = 200$$
);
SELECT * FROM pgr_lineGraphFull(
$$SELECT id, source, target, cost, reverse_cost
FROM edges
WHERE id = 1100$$
);
SELECT * FROM pgr_lineGraphFull(
$$SELECT id, source, target, cost, reverse_cost
FROM edges
WHERE id = 100$$
);
SELECT * FROM pgr_lineGraphFull($$
SELECT id AS id, target, source, reverse_cost AS cost FROM edges WHERE id = 100
UNION
SELECT id, source, target, cost FROM edges WHERE id = 100
$$
);
SELECT * FROM pgr_lineGraphFull($$
SELECT id, target, source, reverse_cost AS cost FROM edges WHERE id = 100
UNION
SELECT -id AS id, source, target, cost FROM edges WHERE id = 100
$$
);
SELECT * FROM pgr_lineGraphFull(
$$SELECT id, source, target, cost, reverse_cost
FROM edges
WHERE id IN (200, 300)$$
);
SELECT * FROM pgr_lineGraphFull(
$$SELECT id * 100 AS id, source * 1000 AS source, target * 1000 AS target,
cost, reverse_cost
FROM edges
WHERE id in (600, 700)$$
);
SELECT * FROM pgr_lineGraphFull(
$$SELECT id * 100 AS id, source * 1000 AS source, target * 1000 AS target,
cost, reverse_cost
FROM edges
where id in (500, 900, 1100)$$
);
|
