|
2 | 2 | TODO list for PostgreSQL |
3 | 3 | ======================== |
4 | 4 | Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us) |
5 | | -Last updated:Wed Mar 2321:11:00 EST 2005 |
| 5 | +Last updated:Wed Mar 2322:50:24 EST 2005 |
6 | 6 |
|
7 | 7 | The most recent version of this document can be viewed at the PostgreSQL web |
8 | 8 | site, http://www.PostgreSQL.org. |
@@ -185,9 +185,11 @@ Data Types |
185 | 185 | o Add support for day-time syntax, INTERVAL '1 2:03:04' |
186 | 186 | DAY TO SECOND |
187 | 187 | o Add support for year-month syntax, INTERVAL '50-6' YEAR TO MONTH |
188 | | -o Interpret syntax that isn't uniquely ISO or PG, like '1:30' or |
189 | | - '1' as ISO syntax, e.g. interpret '1:30' MINUTE TO SECOND as |
190 | | - '1 minute 30 seconds' |
| 188 | +o For syntax that isn't uniquely ISO or PG syntax, like '1:30' or |
| 189 | + '1', treat as ISO if there is a range specification clause, |
| 190 | + and as PG if there no clause is present, e.g. interpret '1:30' |
| 191 | + MINUTE TO SECOND as '1 minute 30 seconds', and interpret '1:30' |
| 192 | + as '1 hour, 30 minutes' |
191 | 193 | o Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS |
192 | 194 | INTERVAL MONTH), and this should return '12 months' |
193 | 195 | o Round or truncate values to the requested precision, e.g. |
|