The following bug has been logged online: Bug reference: 1112 Logged by: Ulf Mehlig
Email address: [EMAIL PROTECTED] 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) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
