diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-03-23 21:10:02 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-03-23 21:10:02 +0000 |
| commit | a15699b9e09f29d1793484b6163d22bcdc6d93f5 (patch) | |
| tree | 1219fdc85fa68536b1edf2ec487afb5f58dce439 | |
| parent | 87ba04eeaf3e13a25f6d5ba803dcb9cbc02cda53 (diff) | |
| download | postgresql-a15699b9e09f29d1793484b6163d22bcdc6d93f5.tar.gz postgresql-a15699b9e09f29d1793484b6163d22bcdc6d93f5.zip | |
Update ANSI INTERVAL section:
< * 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))
| -rw-r--r-- | doc/TODO | 20 |
1 files changed, 11 insertions, 9 deletions
@@ -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 |