PostgreSQL TODO List

====================

Current maintainer:Bruce Momjian (bruce@momjian.us)

Last updated:Wed Mar 2112:43:21 EDT 2007

Last updated:Wed Mar 2117:21:13 EDT 2007

The most recent version of this document can be viewed at

http://www.postgresql.org/docs/faqs.TODO.html.

http://archives.postgresql.org/pgsql-hackers/2007-03/msg01181.php

* Change NUMERIC to enforce the maximum precision

* 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.

* Fix data types where equality comparison isn't intuitive, e.g. box

* Allow user-defined types to specify a type modifier at table creation

time

<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">

<h1><aname="section_1">PostgreSQL TODO List</a></h1>

<p>Current maintainer: Bruce Momjian (<ahref="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>

Last updated: Wed Mar 2112:43:21 EDT 2007

Last updated: Wed Mar 2117:21:13 EDT 2007

<p>The most recent version of this document can be viewed at<br/>

<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.

<ahref="http://archives.postgresql.org/pgsql-hackers/2007-03/msg01181.php">http://archives.postgresql.org/pgsql-hackers/2007-03/msg01181.php</a>

</li><li>Change NUMERIC to enforce the maximum precision

</li><li>Add NUMERIC division operator that doesn't round?

<p> Currently NUMERIC<u>rounds</u> 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 &gt; 10:

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

<p> The positive modulus result returned by NUMERICs might be considered<br/>

inaccurate, in one sense.

<li>Fix data types where equality comparison isn't intuitive, e.g. box

</li><li>Fix data types where equality comparison isn't intuitive, e.g. box

</li><li>Allow user-defined types to specify a type modifier at table creation

time

</li><li>-<em>Allow user-defined types to accept 'typmod' parameters</em>