All Products
Search

This Product

    PolarDB:ST_NodeID

    Document Center

    PolarDB:ST_NodeID

    Last Updated:Mar 28, 2026

    Returns the ID of a node in an SFMesh object by 0-based index.

    Syntax

    Integer ST_NodeID(SFMesh sfmeshObject, integer nodeIndex);

    Parameters

    ParameterDescription
    sfmeshObjectThe SFMesh object.
    nodeIndexThe index of the node. Indexing starts at 0.

    Description

    ST_NodeID returns the integer ID assigned to the node at position nodeIndex within sfmeshObject. The index is 0-based: index 0 refers to the first node, index 1 refers to the second, and so on.

    Examples

    The following example sets the ID of node 0 to 100 using ST_SetNodeID, then retrieves it with ST_NodeID. The query returns 100.

    SELECT ST_NodeID(ST_SetNodeID(the_mesh, 0, 100), 0)
FROM t_table;

-------------------
100

    See also

    • ST_SetNodeID: Sets the ID of a node in an SFMesh object.