All Products
Search
Document Center

PolarDB:ST_ClearBinData

Last Updated:Mar 28, 2026

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

Syntax

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

Parameters

ParameterDescription
sfmeshObjectThe sfmesh object to clear binary data from.
materialThe material object to clear binary data from.

Examples

The following example clears binary data from the the_mesh column and verifies the result using ST_HasBinData. The function returns f (false), confirming that no binary data remains.

SELECT ST_HasBinData(ST_ClearBinData(the_mesh))
FROM t_table;

-------------------
f