I am looking for a possibillity to round the result of ST_Distance
on two digits.
If I try
select g.id ,round(ST_Distance(g.geom, p.geom), 2) dist_m
I get:
Funktion round(double precision, integer) existiert nicht
function round(double precision, integer) does not exist