BUG #1112: round(float-type does not work) - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      1112
Logged by:          Ulf Mehlig

Email address:      ulf.mehlig@zmt-bremen.de

PostgreSQL version: 7.4

Operating system:   Debian Linux/i386 "testing"

Description:        round(float-type does not work)

Details:

After upgrading to 7.4.2 I just discovered that the round(f,d) function does
not work as expected (bug or feature?):

 xxx=> select round(pi(), 2);
 ERROR:  function round(double precision, integer) does  not exist
 HINT:  No function matches the given name and argument  types. You may need
to add explicit type casts.

Typecasting to "NUMERIC" helps, but in my opinion it should not be necessary
to typecast float values for rounding:

xxx=> select round(pi()::numeric, 2);
 round
-------
  3.14
(1 row)