[postgis-users] Trim ST_Y / ST_X

[Wolf-E. Altmann]

And what about round(st_x(geom)::numeric, 5)?

Wolf

Am 04.06.2016 um 04:15 schrieb 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
> <mailto: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
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160604/28d6f374/attachment.html>