From 669111800fafbe548882b01b26cf73df3225f9fb Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 25 Jun 2005 01:32:02 +0000 Subject: 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. > --- doc/src/FAQ/TODO.html | 16 ++++++++++++++-- 1 file changed, 14 insertions(+), 2 deletions(-) (limited to 'doc/src') diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index e17f3bbb936..db637523eba 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@

PostgreSQL TODO List

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
-Last updated: Fri Jun 24 17:28:23 EDT 2005 +Last updated: Fri Jun 24 21:32:02 EDT 2005

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html. @@ -142,7 +142,19 @@ first.

Remove Money type, add money formatting for decimal type
Change NUMERIC to enforce the maximum precision, and increase it -
Add function to return compressed length of TOAST data values +
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. +

Add function to return compressed length of TOAST data values
Allow INET subnet tests using non-constants to be indexed
Add transaction_timestamp(), statement_timestamp(), clock_timestamp() functionality -- cgit v1.2.3