Skip to content

Commit 5fc7ba7

Browse files
committed
Remove TODO item, not wanted:
< * 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. <
1 parent 17fdd78 commit 5fc7ba7

File tree

2 files changed

+3
-26
lines changed

2 files changed

+3
-26
lines changed

doc/TODO

Lines changed: 1 addition & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer: Bruce Momjian (bruce@momjian.us)
5-
Last updated: Wed Mar 21 12:43:21 EDT 2007
5+
Last updated: Wed Mar 21 17:21:13 EDT 2007
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -185,17 +185,6 @@ Data Types
185185
http://archives.postgresql.org/pgsql-hackers/2007-03/msg01181.php
186186

187187
* Change NUMERIC to enforce the maximum precision
188-
* Add NUMERIC division operator that doesn't round?
189-
190-
Currently NUMERIC _rounds_ the result to the specified precision.
191-
This means division can return a result that multiplied by the
192-
divisor is greater than the dividend, e.g. this returns a value > 10:
193-
194-
SELECT (10::numeric(2,0) / 6::numeric(2,0))::numeric(2,0) * 6;
195-
196-
The positive modulus result returned by NUMERICs might be considered
197-
inaccurate, in one sense.
198-
199188
* Fix data types where equality comparison isn't intuitive, e.g. box
200189
* Allow user-defined types to specify a type modifier at table creation
201190
time

doc/src/FAQ/TODO.html

Lines changed: 2 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF">
99
<h1><a name="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<a href="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>
11-
Last updated: Wed Mar 21 12:43:21 EDT 2007
11+
Last updated: Wed Mar 21 17:21:13 EDT 2007
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<a href="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -168,19 +168,7 @@ <h1><a name="section_4">Data Types</a></h1>
168168
<a href="http://archives.postgresql.org/pgsql-hackers/2007-03/msg01181.php">http://archives.postgresql.org/pgsql-hackers/2007-03/msg01181.php</a>
169169
</p>
170170
</li><li>Change NUMERIC to enforce the maximum precision
171-
</li><li>Add NUMERIC division operator that doesn't round?
172-
<p> Currently NUMERIC <u>rounds</u> the result to the specified precision.
173-
This means division can return a result that multiplied by the
174-
divisor is greater than the dividend, e.g. this returns a value &gt; 10:
175-
</p>
176-
</li></ul>
177-
<p> SELECT (10::numeric(2,0) / 6::numeric(2,0))::numeric(2,0) * 6;
178-
</p>
179-
<p> The positive modulus result returned by NUMERICs might be considered<br/>
180-
inaccurate, in one sense.
181-
</p>
182-
<ul>
183-
<li>Fix data types where equality comparison isn't intuitive, e.g. box
171+
</li><li>Fix data types where equality comparison isn't intuitive, e.g. box
184172
</li><li>Allow user-defined types to specify a type modifier at table creation
185173
time
186174
</li><li>-<em>Allow user-defined types to accept 'typmod' parameters</em>

0 commit comments

Comments
 (0)