[postgis-users] set nr of decimales without changing field type
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