ST_SetNodeID

更新时间: 2026-03-28 12:16:00

Sets the ID of a node in an SFMesh object.

Syntax

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

Parameters

ParameterDescription
sfmeshObjectThe SFMesh object.
nodeIndexThe zero-based index of the node.
idA user-defined integer identifier to associate with the node. Use this to link a node to an external object, such as a record in another table.

Description

Sets the ID of the node at the specified index to the given integer value. To retrieve a node ID after setting it, call ST_NodeID.

Examples

The following example sets the node at index 0 to ID 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;

Result:

100

What's next

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

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