Hi

what should a no_search latch return?

Given the data below, there is only one directed link between vertexes 1,2 and
one directed link between vertexes 2,1

So by my logic if you are looking for 'things' with a destid of vertex 2 and
and source vertext of 1 then only one row should be returned?

INSERT INTO graph_base(from_id, to_id) VALUES (1,2), (2,1);
INSERT INTO graph_base(from_id, to_id) VALUES (1,3), (3,1);
INSERT INTO graph_base(from_id, to_id) VALUES (3,4), (4,3);
INSERT INTO graph_base(from_id, to_id) VALUES (5,6), (6,5);

SELECT * FROM graph WHERE latch='no_search' and destid=2 and origid=1;

yields

latch   origid  destid  weight  seq     linkid
no_search       1       2       1       3       1
no_search       1       2       1       2       3
no_search       1       2       1       1       2


(And simlar for the integer latch equivalent)

latch   origid  destid  weight  seq     linkid
0       1       2       1       3       1
0       1       2       1       2       3
0       1       2       1       1       2

--Andrew

-- 
Mailing list: https://launchpad.net/~oqgraph-dev
Post to     : oqgraph-dev@lists.launchpad.net
Unsubscribe : https://launchpad.net/~oqgraph-dev
More help   : https://help.launchpad.net/ListHelp

Reply via email to