Skip to main content
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)