ERROR: function round(double precision, integer) does not exist
I had the same problem with geograpic coordinates. The longitude was in double precision from the open street map data and needed a rouded value. My solution work fine: select ROUND(CAST(longitude AS numeric),2) from my_points;