diff options
Diffstat (limited to 'doc/src/FAQ/TODO.html')
| -rw-r--r-- | doc/src/FAQ/TODO.html | 16 |
1 files changed, 14 insertions, 2 deletions
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 @@ <body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF"> <h1><a name="section_1">PostgreSQL TODO List</a></h1> <p>Current maintainer: Bruce Momjian (<a href="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/> -Last updated: Fri Jun 24 17:28:23 EDT 2005 +Last updated: Fri Jun 24 21:32:02 EDT 2005 </p> <p>The most recent version of this document can be viewed at<br/> <a href="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>. @@ -142,7 +142,19 @@ first. <ul> <li>Remove Money type, add money formatting for decimal type </li><li>Change NUMERIC to enforce the maximum precision, and increase it - </li><li>Add function to return compressed length of TOAST data values + </li><li>Add NUMERIC division operator that doesn't round? +<p> 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: +</p> +</li></ul> +<p> SELECT (10::numeric(2,0) / 6::numeric(2,0))::numeric(2,0) * 6; +</p> +<p> The positive modulus result returned by NUMERICs might be considered<br/> + inaccurate, in one sense. +</p> +<ul> + <li>Add function to return compressed length of TOAST data values </li><li>Allow INET subnet tests using non-constants to be indexed </li><li>Add transaction_timestamp(), statement_timestamp(), clock_timestamp() functionality |