ST_SetTileOption-PolarDB(PolarDB)-阿里云帮助中心

Sets the tile option for an sfmesh object and returns the updated object.

Syntax

sfmesh ST_SetTileOption(sfmesh sfmesh, cstring option);

Parameters

Parameter	Description
`sfmesh`	The sfmesh object.
`option`	The tile option as a JSON string.

Description

ST_SetTileOption configures how tiles are generated for an sfmesh object. Pass the option parameter as a JSON string with the following fields:

Field	Description
`with_geometry`	Specifies whether geometry objects are included in the tile.
`with_submesh`	Specifies whether child sfmesh objects are included in the tile.

Example option value:

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

Examples

The following example sets the tile option to exclude geometry objects but include child sfmesh objects, then reads back the configured option using ST_TileOption:

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

Output:

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