This topic describes the ST_SetUpdatePyramidRules function. This function sets the update rules for the ST_UpdatePyramid function.

Syntax

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

Parameters

Parameter Description
table The name of the vector table.
geom_field The name of the column that has the Geometry attribute in the vector table.
rules The rule for the update in the JSON format. The settings of updateBoxScale or updateExtentSRS affect the update operation. 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)