ST_Name function returns the name of a material or texture object - PolarDB

Returns the name of a material or texture object.

Syntax

cstring ST_Name(texture texture);
cstring ST_Name(material material);

Parameter	Description
`texture`	The texture object.
`material`	The material object.

ST_Name returns the name set on a material or texture object by ST_SetName.

Call ST_SetName before calling ST_Name. The function returns only the name configured by ST_SetName.

Example 1: Get the name of a material object.

SELECT ST_Name(ST_SetName(the_material, 'material_name'))
FROM t_table

-------------------
material_name

Example 2: Get the name of a texture object.

SELECT ST_Name(ST_SetName(the_texture, 't_name'))
FROM t_table

-------------------
t_name