Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.wherobots.com/llms.txt

Use this file to discover all available pages before exploring further.

Reduce the decimals places in the coordinates of the geometry to the given number of decimal places. The last decimal place will be rounded. This function was called ST_PrecisionReduce in versions prior to v1.5.0. ST_ReducePrecision

​
Signatures

ST_ReducePrecision (A: Geometry, B: Integer)

​
Parameters

​
A
Geometry
required
The input geometry.
​
B
Integer
required
The second geometry.

​
Return type

The resulting geometry.

​
Example

SELECT ST_ReducePrecision(ST_GeomFromWKT('Point(0.1234567890123456789 0.1234567890123456789)')
    , 9)
The new coordinates will only have 9 decimal places. 
POINT (0.123456789 0.123456789)