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
|
/* :file: This file is part of the pgRouting project.
:copyright: Copyright (c) 2013-2026 pgRouting developers
:license: Creative Commons Attribution-Share Alike 3.0 https://creativecommons.org/licenses/by-sa/3.0 */
BEGIN;
SELECT plan(1);
CREATE OR REPLACE FUNCTION test_function()
RETURNS SETOF TEXT AS
$BODY$
BEGIN
IF NOT min_version('3.2.0') THEN
RETURN QUERY
SELECT skip(1, 'Combinations signature added on 3.2.0');
RETURN;
END IF;
RETURN query SELECT is_empty(
'SELECT seq, path_seq, node, edge, cost, agg_cost FROM pgr_binaryBreadthFirstSearch(
''SELECT id, source, target, cost, reverse_cost FROM edges'',
''SELECT * FROM combinations WHERE source IN (-1)'' ) '
);
RETURN;
END
$BODY$
language plpgsql;
SELECT * FROM test_function();
-- Finish the tests and clean up.
SELECT * FROM finish();
ROLLBACK;
|
