Обсуждение: BUG #1112: round(float-type does not work)

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)

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.