Control sfmesh Tile Geometry Using ST_SetTileOption - PolarDB

Configures a custom tile option for an sfmesh object.

Syntax

sfmesh ST_SetTileOption(sfmesh sfmesh, cstring option);

Parameter	Description
sfmesh	The sfmesh object.
option	The value of the option. The value is in JSON format.

This function configures a custom tile option. The value of the option parameter is a JSON string that contains the following fields:

Field	Description
with_geometry	Specifies whether geometry objects are included.
with_submesh	Specifies whether child sfmesh objects are included.

Example:

{
  "with_geometry" : true,
  "with_submesh" : true
}

SELECT ST_TileOption(ST_SetTileOption(the_mesh, '{"with_geometry":false,"with_submesh":true}'))
FROM t_table

Result:

-------------------
{"with_geometry":false,"with_submesh":true}