[postgis-users] Trim ST_Y / ST_X

Sandro Santilli strk at kbt.io
Thu Jun 2 23:10:33 PDT 2016


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


More information about the postgis-users mailing list