How to round an average to 2 decimal places in PostgreSQL?
PostgreSQL does not define round(double precision, integer). For reasons @Mike Sherrill ‘Cat Recall’ explains in the comments, the version of round that takes a precision is only available for numeric. regress=> SELECT round( float8 ‘3.1415927’, 2 ); ERROR: function round(double precision, integer) does not exist regress=> \df *round* List of functions Schema | Name | … Read more