Thread: Round(DP Or numeric ) returns integer

Round(DP Or numeric ) returns integer

From
PG Doc comments form
Date:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/functions-math.html
Description:

1) The function round( dp or numeric ) always has return type integer not
same as our parameter is.
2) The function round( dp or numeric, s int ) returns the same type as our
parameter is not an integer type.

Re: Round(DP Or numeric ) returns integer

From
Tom Lane
Date:
PG Doc comments form <noreply@postgresql.org> writes:
> 1) The function round( dp or numeric ) always has return type integer not
> same as our parameter is.
> 2) The function round( dp or numeric, s int ) returns the same type as our
> parameter is not an integer type.

Huh?

postgres=# \df round
                         List of functions
   Schema   | Name  | Result data type | Argument data types | Type 
------------+-------+------------------+---------------------+------
 pg_catalog | round | double precision | double precision    | func
 pg_catalog | round | numeric          | numeric             | func
 pg_catalog | round | numeric          | numeric, integer    | func
(3 rows)

The description in the docs matches reality AFAICS.

            regards, tom lane