title: ERROR: function round(double precision, integer) does not exist
body: <p>I am in the middle of migrating some queries which have been running for ages with MySQL database which is now in Postgres having the same structure. I got stuck with a simple round function which ends with the following error message.</p>
  <blockquote>
  <p>ERROR: function round(double precision, integer) does not exist</p>
  </blockquote>
  <p>part of the select which does not work:</p>
  <pre><code>round(floor(pools.available_capacity_in_kb/1024/1024/1024*100)/100,2) as free,
  </code></pre>
  <p><code>pools.available_capacity_in_kb</code> is stored as BIGINT in the database (Postgres 10.9)</p>