Update ANSI INTERVAL section:

bmomjian · bmomjian · commit a15699b9e09f · 2005-03-23T21:10:02.000Z
&lt; * Add support for ANSI time INTERVAL syntax, INTERVAL '1 2:03:04' DAY TO SECOND
&lt; * Add support for ANSI date INTERVAL syntax, INTERVAL '20-6' YEAR TO MONTH
&lt; * Process mixed ANSI/PG INTERVAL syntax, and round value to requested precision
&lt;
&lt;   Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS INTERVAL
&lt;   MONTH), and this should return '12 months'
&lt;
&lt; * Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 minute 30 seconds'
&gt; * Add ANSI INTERVAL handling
&gt; 	o Add support for day-time syntax, INTERVAL '1 2:03:04'
&gt; 	  DAY TO SECOND
&gt; 	o Add support for year-month syntax, INTERVAL '50-6' YEAR TO MONTH
&gt; 	o Process mixed ANSI/PG syntax, and round value to requested
&gt; 	  precision or generate an error
&gt; 	o Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS
&gt; 	  INTERVAL MONTH), and this should return '12 months'
&gt; 	o Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 minute 30 seconds'
&gt; 	o Support precision, CREATE TABLE foo (a INTERVAL MONTH(3))
diff --git a/doc/TODO b/doc/TODO
@@ -2,7 +2,7 @@
 TODO list for PostgreSQL
 ========================
 Current maintainer:	Bruce Momjian (pgman@candle.pha.pa.us)
-Last updated:		Wed Mar 23 12:05:12 EST 2005
+Last updated:		Wed Mar 23 16:09:58 EST 2005
 
 The most recent version of this document can be viewed at the PostgreSQL web
 site, http://www.PostgreSQL.org.
@@ -181,14 +181,16 @@ Data Types
   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
