diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-03-24 03:50:24 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-03-24 03:50:24 +0000 |
| commit | 0275b3f783731f7fa95ea8b93ad3f48fc7a2f29f (patch) | |
| tree | fc9d81345f8da73823c60f8b049a188bba625f55 | |
| parent | 0ca91482fa1b2f1c01f926503b3de29291d315fc (diff) | |
| download | postgresql-0275b3f783731f7fa95ea8b93ad3f48fc7a2f29f.tar.gz postgresql-0275b3f783731f7fa95ea8b93ad3f48fc7a2f29f.zip | |
Update INTERVAL items.
| -rw-r--r-- | doc/TODO | 10 |
1 files changed, 6 insertions, 4 deletions
@@ -2,7 +2,7 @@ TODO list for PostgreSQL ======================== Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) -Last updated: Wed Mar 23 21:11:00 EST 2005 +Last updated: Wed Mar 23 22:50:24 EST 2005 The most recent version of this document can be viewed at the PostgreSQL web site, http://www.PostgreSQL.org. @@ -185,9 +185,11 @@ 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 Interpret syntax that isn't uniquely ISO or PG, like '1:30' or - '1' as ISO syntax, e.g. interpret '1:30' MINUTE TO SECOND as - '1 minute 30 seconds' + o For syntax that isn't uniquely ISO or PG syntax, like '1:30' or + '1', treat as ISO if there is a range specification clause, + and as PG if there no clause is present, e.g. interpret '1:30' + MINUTE TO SECOND as '1 minute 30 seconds', and interpret '1:30' + as '1 hour, 30 minutes' 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. |