ST_ClearBinData

更新时间: 2026-03-28 05:38:36

Clears user-defined binary data from an sfmesh or material object and returns the modified object.

Syntax

sfmesh ST_ClearBinData(sfmesh sfmeshObject);
material ST_ClearBinData(material material);

Parameters

ParameterDescription
sfmeshObjectThe sfmesh object.
materialThe material object.

Return value

Returns the input object with its binary data cleared. The return type matches the input type: sfmesh for the first overload and material for the second.

Examples

The following example clears binary data from the the_mesh column and confirms the result using ST_HasBinData. The return value f (false) indicates that no binary data remains.

SELECT ST_HasBinData(ST_ClearBinData(the_mesh))
FROM t_table;

-------------------
f
上一篇: ST_BinData 下一篇: ST_TileOption
阿里云首页 云原生数据库 PolarDB 相关技术圈