TODO list for PostgreSQL

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

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

Last updated:Wed Mar 2312:05:12 EST 2005

Last updated:Wed Mar 2316:09:58 EST 2005

The most recent version of this document can be viewed at the PostgreSQL web

site, http://www.PostgreSQL.org.

zero the bits

* Prevent INET cast to CIDR from droping netmask, SELECT '1.1.1.1'::inet::cidr

* Add 'tid != tid ' operator for use in corruption recovery

* Add support for ANSI time INTERVAL syntax, INTERVAL '1 2:03:04' DAY TO SECOND

* Add support for ANSI date INTERVAL syntax, INTERVAL '20-6' YEAR TO MONTH

* Process mixed ANSI/PG INTERVAL syntax, and round value to requested precision

Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS INTERVAL

MONTH), and this should return '12 months'

* Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 minute 30 seconds'

* Add ANSI INTERVAL handling

o Add support for day-time syntax, INTERVAL '1 2:03:04'

DAY TO SECOND

o Add support for year-month syntax, INTERVAL '50-6' YEAR TO MONTH

o Process mixed ANSI/PG syntax, and round value to requested

precision or generate an error

o Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS

INTERVAL MONTH), and this should return '12 months'

o Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 minute 30 seconds'

o Support precision, CREATE TABLE foo (a INTERVAL MONTH(3))

* ARRAYS

o Allow NULLs in arrays