PostgreSQL TODO List

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

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

Last updated:Mon Apr 217:27:56 EDT 2007

Last updated:Mon Apr 218:46:07 EDT 2007

The most recent version of this document can be viewed at

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

o Fix SELECT '0.01 years'::interval, '0.01 months'::interval

o Add a GUC variable to allow output of interval values in ISO8601

format

o Have timestamp subtraction not call justify_hours()?

http://archives.postgresql.org/pgsql-sql/2006-10/msg00059.php

o Improve timestamptz subtraction to be DST-aware

Currently subtracting one date from another that crosses a

if daylight savings adjustments are involved.

o Fix interval display to support values exceeding 2^31 hours

o Add overflow checking to timestamp and interval arithmetic

o Add overflow checking to timestamp and interval arithmetic

o Extend timezone code to allow 64-bit values so we can

represent years beyond 2038

<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: Mon Apr 217:27:56 EDT 2007

Last updated: Mon Apr 218:46:07 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>.

</li><li>Fix SELECT '0.01 years'::interval, '0.01 months'::interval

</li><li>Add a GUC variable to allow output of interval values in ISO8601

format

</li><li>Have timestamp subtraction not call justify_hours()?

<p><ahref="http://archives.postgresql.org/pgsql-sql/2006-10/msg00059.php">http://archives.postgresql.org/pgsql-sql/2006-10/msg00059.php</a>

</li><li>Improve timestamptz subtraction to be DST-aware

<p> Currently subtracting one date from another that crosses a

daylight savings time adjustment can return '1 day 1 hour', but

if daylight savings adjustments are involved.

</li><li>Fix interval display to support values exceeding 2^31 hours

</li><li>Add overflow checking to timestamp and interval arithmetic

</li><li>Add overflow checking to timestamp and interval arithmetic

</li><li>Extend timezone code to allow 64-bit values so we can

represent years beyond 2038

<p><ahref="http://archives.postgresql.org/pgsql-hackers/2006-09/msg01363.php">http://archives.postgresql.org/pgsql-hackers/2006-09/msg01363.php</a>