All Products
Search
Document Center

PolarDB:ST_SetNodeID

Last Updated:Mar 28, 2026

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