Ancestors() function
The Ancestors() function is an iterator function that returns ancestor nodes. The Ancestors function recursively calls itself with the output from IsAncestor.
Syntax
Ancestors(node)
- node
- The node for which you want to find all ancestor nodes.
Example
EXECUTE FUNCTION ancestors('1.2.3.4.5.6.7.8.9');
This
function returns the following eight rows as ancestor nodes:1.2.3.4.5.6.7.8
1.2.3.4.5.6.7
1.2.3.4.5.6
1.2.3.4.5
1.2.3.4
1.2.3
1.2
1.0