PG Doc comments form <nore...@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