Round(DP Or numeric ) returns integer
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.
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