[postgis-users] Trim ST_Y / ST_X

[Chris B]

I've stopped using the ST_X(geom) is there a way to round to the 5th
decimal place on just the column lat round does not work the type is double
precision

On Fri, Jun 3, 2016 at 1:10 AM, Sandro Santilli <strk at kbt.io> wrote:

> On Fri, Jun 03, 2016 at 12:19:32AM -0500, Chris B wrote:
> > Can someone help with the command to trim past the 5th decimal place?
>
>
> Something like this ?
>
>   # select round(0.123456789, 5);
>     round
>   ---------
>    0.12346
>   (1 row)
>
> --strk;
>
>   ()   Free GIS & Flash consultant/developer
>   /\   https://strk.kbt.io/services.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160603/bcce763e/attachment.html>