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.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)

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

C.