| 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 |
|