Fix a bug in input processing for the "interval" type. Previously,
Neil Conway <neilc@samurai.com>
Fix a bug in input processing for the "interval" type. Previously, "microsecond" and "millisecond" units were not considered valid input by themselves, which caused inputs like "1 millisecond" to be rejected erroneously. Update the docs, add regression tests, and backport to 8.2 and 8.1
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/datatype.sgml | modified | +3 −2 |
| src/backend/utils/adt/datetime.c | modified | +14 −2 |
| src/include/utils/datetime.h | modified | +15 −11 |
| src/test/regress/expected/interval.out | modified | +23 −0 |
| src/test/regress/sql/interval.sql | modified | +11 −0 |