[postgis-users] set nr of decimales without changing field type

Gery . gamejihou at hotmail.com
Fri Oct 7 09:33:05 PDT 2011


I'm calculating some distances and getting too many decimals, I just want 4 decimals, this is the code:

UPDATE line SET length_km = st_length(st_transform(geom,32718))/1000 WHERE id::int between 1 and 75;

and the result is for example:


Is it possible to set the number of decimals in the code above?


More information about the postgis-users mailing list