Re: BUG #1112: round(float-type does not work)

hi,

PostgreSQL Bugs List wrote:
> The following bug has been logged online:
>
> Bug reference: 1112
> Logged by: Ulf Mehlig
>
> Email address: ulf(dot)mehlig(at)zmt-bremen(dot)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)

create function round (double precision,integer) returns numeric as '
select round($1::numeric, $2); ' language sql immutable;

C.