ST_SetNodeID

更新时间: 2026-03-28 16:59:10

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

上一篇: ST_SetUserData 下一篇: ST_NodeID
阿里云首页 云原生数据库 PolarDB 相关技术圈