<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
And what about round(st_x(geom)::numeric, 5)?<br>
<br>
Wolf<br>
<br>
<div class="moz-cite-prefix">Am 04.06.2016 um 04:15 schrieb Chris B:<br>
</div>
<blockquote
cite="mid:CADaZbwHA76kdGR8pW8403SvTubjTNKhCm+RtdtXGgjnji_x01Q@mail.gmail.com"
type="cite">
<pre wrap="">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 <<a class="moz-txt-link-abbreviated" href="mailto:strk@kbt.io">strk@kbt.io</a>
<a class="moz-txt-link-rfc2396E" href="mailto:strk@kbt.io"><mailto:strk@kbt.io></a>> 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
/\ <a class="moz-txt-link-freetext" href="https://strk.kbt.io/services.html">https://strk.kbt.io/services.html</a>
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/postgis-users">http://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</body>
</html>