> ## 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.

# ST_ReducePrecision

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.

<img src="https://mintcdn.com/wherobots/wLm_IRUSNlHZTHJP/images/sql-functions/ST_ReducePrecision/ST_ReducePrecision.svg?fit=max&auto=format&n=wLm_IRUSNlHZTHJP&q=85&s=35c7fa5ef8cc51e3da6c39e2eb503e73" alt="ST_ReducePrecision" width="500" height="300" data-path="images/sql-functions/ST_ReducePrecision/ST_ReducePrecision.svg" />

## Signatures

```sql theme={"system"}
ST_ReducePrecision (A: Geometry, B: Integer)
```

## Parameters

<ParamField body="A" type="Geometry" required>
  The input geometry.
</ParamField>

<ParamField body="B" type="Integer" required>
  The second geometry.
</ParamField>

## Return type

<ResponseField type="Geometry">
  The resulting geometry.
</ResponseField>

## Example

```sql theme={"system"}
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)
```