All Products
Search
Document Center

PolarDB:ST_HasBinData

Last Updated:Mar 28, 2026

ST_HasBinData checks whether an sfmesh or material object has user-defined binary data attached.

Returns true if the object carries binary data set by ST_SetBinData; returns false if no binary data has been attached.

Syntax

boolean ST_HasBinData(sfmesh sfmeshObject);
boolean ST_HasBinData(material material);

Parameters

ParameterDescription
sfmeshObjectThe sfmesh object to check.
materialThe material object to check.

Examples

Check whether an sfmesh object has binary data attached. The result is true because ST_SetBinData attached binary data to the object first.

SELECT ST_HasBinData(ST_SetBinData(the_mesh, 'abc'::bytea))
FROM t_table;

-------------------
t

Related functions

  • ST_SetBinData — attach binary data to an sfmesh or material object