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 <[email protected]> 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 [email protected] http://lists.osgeo.org/mailman/listinfo/postgis-users
