PostgreSQL TODO List

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

Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)

Last updated:Fri Jun 2417:28:23 EDT 2005

Last updated:Fri Jun 2421:32:02 EDT 2005

The most recent version of this document can be viewed at

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

* 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()

<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:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>

Last updated: Fri Jun 2417:28:23 EDT 2005

Last updated: Fri Jun 2421:32:02 EDT 2005

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

<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 &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>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