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