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

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)