All Products
Search
Document Center

PolarDB:ST_ClearBinData

Last Updated:Mar 28, 2026

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