ST_SetUpdatePyramidRules-ApsaraDB RDS(RDS)-阿里云帮助中心

This topic describes how to set the parameters of the update policy for ST_UpdatePyramid.

Syntax

boolean ST_SetUpdatePyramidRules(cstring table, cstring geom_field, cstring rules);

Parameters

Parameter Name	Description
table	The name of the vector table.
geom_field	The name of the Geometry property column in the vector table.
rules	The update parameters in JSON format. Only the updateBoxScale and updateExtentSRS parameters affect the update behavior. For more information about updateBoxScale and updateExtentSRS, see ST_UpdatePyramid.

Examples

SELECT ST_SetupdatePyramidRules('test_update_line', 'geom', '{"updateBoxScale":100000}');
st_setupdatepyramidrules
--------------------------
t
(1 row)