pgsql: Add item: > * Add NUMERIC division operator that doesn't round?

Started by Bruce Momjianabout 21 years ago1 messagescomitters
Jump to latest
#1Bruce Momjian
bruce@momjian.us

Log Message:
-----------
Add item:

* Add NUMERIC division operator that doesn't round?

Currently NUMERIC _rounds_ the result to the specified precision.
This means division can return a result that multiplied by the
divisor is greater than the dividend, e.g. this returns a value > 10:

SELECT (10::numeric(2,0) / 6::numeric(2,0))::numeric(2,0) * 6;

The positive modulus result returned by NUMERICs might be considered
inaccurate, in one sense.

Modified Files:
--------------
pgsql/doc:
TODO (r1.1573 -> r1.1574)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1573&r2=1.1574)
pgsql/doc/src/FAQ:
TODO.html (r1.80 -> r1.81)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.80&r2=1.81)