diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-03-23 22:57:02 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-03-23 22:57:02 +0000 |
| commit | 8abba638599113e8c742c6f97a204c625db36b43 (patch) | |
| tree | 639fb1aadfc61c963c046a40943548b4cbf94df8 | |
| parent | d5dd9dbbfe68962c67a40fa9bc08678d83777a2c (diff) | |
| download | postgresql-8abba638599113e8c742c6f97a204c625db36b43.tar.gz postgresql-8abba638599113e8c742c6f97a204c625db36b43.zip | |
Update wording:
< 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'
194a191,194
> o Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS
> INTERVAL MONTH), and this should return '12 months'
> o Round or truncate values to the requested precision, e.g.
> INTERVAL '11 months' AS YEAR should return one or zero
| -rw-r--r-- | doc/TODO | 10 |
1 files changed, 5 insertions, 5 deletions
@@ -2,7 +2,7 @@ TODO list for PostgreSQL ======================== Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) -Last updated: Wed Mar 23 16:49:42 EST 2005 +Last updated: Wed Mar 23 17:57:00 EST 2005 The most recent version of this document can be viewed at the PostgreSQL web site, http://www.PostgreSQL.org. @@ -185,13 +185,13 @@ Data Types 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 syntax that isn't uniquely ANSI or PG, like '1:30' or '1' as ANSI syntax, e.g. interpret '1:30' MINUTE TO SECOND as '1 minute 30 seconds' + o Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS + INTERVAL MONTH), and this should return '12 months' + o Round or truncate values to the requested precision, e.g. + INTERVAL '11 months' AS YEAR should return one or zero o Support precision, CREATE TABLE foo (a INTERVAL MONTH(3)) * ARRAYS |