Debian Codegraph @

modules/phylogeny/functions/phylo.plpgsql

raw
1
2 CREATE OR REPLACE FUNCTION phylonode_depth(bigint)
3 RETURNS FLOAT AS
4 'DECLARE id ALIAS FOR $1;
5 DECLARE depth FLOAT := 0;
6 DECLARE curr_node phylonode%ROWTYPE;
7 BEGIN
8 SELECT INTO curr_node *
9 FROM phylonode
10 WHERE phylonode_id=id;
11 depth = depth + curr_node.distance;
12 IF curr_node.parent_phylonode_id IS NULL
13 THEN RETURN depth;
14 ELSE RETURN depth + phylonode_depth(curr_node.parent_phylonode_id);
15 END IF;
16 END
17 '
18 LANGUAGE 'plpgsql';
19
20 CREATE OR REPLACE FUNCTION phylonode_height(bigint)
21 RETURNS FLOAT AS
22 '
23 SELECT coalesce(max(phylonode_height(phylonode_id) + distance), 0.0)
24 FROM phylonode
25 WHERE parent_phylonode_id = $1
26 '
27 LANGUAGE 'sql';
28