ST_HasBinData function to check for user-defined binary data - PolarDB

Determines whether user-defined binary data is returned for an sfmesh or material object.

Syntax

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

Parameter	Type	Description
`sfmeshObject`	`sfmesh`	The sfmesh object to check.
`material`	`material`	The material object to check.

Check whether the mesh in t_table has binary data attached:

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

Result:

t indicates true — binary data is present on the object.