Re: Round(DP Or numeric ) returns integer
Tom Lane <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.documentation |
|---|---|
| Message-ID | <[email protected]> |
PG Doc comments form <[email protected]> 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