GetMember() function

The GetMember( ) function returns information about a node level, returns integer. The GetMember() function returns specific parts of the node argument. The second argument specifies the level you want returned. A NULL is returned if no corresponding level exists.

Returns: integer or NULL

Syntax

GetMember(node, integer)

node

integer

Example

CREATE TABLE nodetab1 (col1 node);
INSERT INTO nodetab1 VALUES ('1.0');
INSERT INTO nodetab1 VALUES ('1.1.1');
INSERT INTO nodetab1 VALUES ('1.1.2');
INSERT INTO nodetab1 VALUES ('1.1.2.1');
INSERT INTO nodetab1 VALUES ('2.0');

SELECT  col1, GetMember(col1, 3)
FROM    nodetab1;

col1          1.0 
(expression)  

col1          1.1.1 
(expression)  1

col1          1.1.2 
(expression)  2

col1          1.1.2.1 
(expression)  2

col1          2.0 
(expression)