diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-06-25 01:32:02 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-06-25 01:32:02 +0000 |
| commit | 669111800fafbe548882b01b26cf73df3225f9fb (patch) | |
| tree | cffaaaeb17d69b19a513c744a2c2227eaa850b90 | |
| parent | f3dbacab0c033ab43b8a6378cdb1ee368018bcd2 (diff) | |
| download | postgresql-669111800fafbe548882b01b26cf73df3225f9fb.tar.gz postgresql-669111800fafbe548882b01b26cf73df3225f9fb.zip | |
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.
>
| -rw-r--r-- | doc/TODO | 13 | ||||
| -rw-r--r-- | doc/src/FAQ/TODO.html | 16 |
2 files changed, 26 insertions, 3 deletions
@@ -2,7 +2,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. @@ -152,6 +152,17 @@ Data Types * Remove Money type, add money formatting for decimal type * Change NUMERIC to enforce the maximum precision, and increase it +* 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() 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 |