ST_SetNodeID-PolarDB(PolarDB)-阿里云帮助中心

This topic describes the ST_SetNodeID function. This function configures the ID of the specified node.

Syntax

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

Parameters

Parameter name	Description
sfmeshObject	The SFMesh object.
nodeIndex	The index of the node. The index starts from 0.
id	The ID of the object to associate with the specified node.

Description

This function sets the ID of the node to the ID of the object that is associated with the node. You can call the ST_NodeID operation to obtain the ID of the node.

Examples

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

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