All Products
Search
Document Center

PolarDB:ST_SetNodeID

Last Updated:Mar 28, 2026

Returns an SFMesh object with the node at the specified index assigned a new integer ID.

Syntax

SFMesh ST_SetNodeID(SFMesh sfmeshObject, integer nodeIndex, integer id);

Parameters

ParameterDescription
sfmeshObjectThe SFMesh object to modify.
nodeIndexThe zero-based index of the node.
idThe ID of the specified node. The value can be set to the ID of the object that is associated with the node.

Return value

Returns the modified SFMesh object with the node ID updated. To read back the ID after setting it, call ST_NodeID.

Example

The following example sets the ID of the node at index 0 to 100, then reads it back with ST_NodeID to verify the result.

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

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

What's next

  • ST_NodeID — retrieves the ID of a node in an SFMesh object