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

[Gery .]

Hi,

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:

75.1634098489817

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

Thanks,