Fix interval input parser so that fractional weeks and months are
Tom Lane <tgl@sss.pgh.pa.us>
Fix interval input parser so that fractional weeks and months are cascaded first to days and only what is leftover into seconds. This seems to satisfy the principle of least surprise given the general conversion to three-part interval values --- it was an oversight that these cases weren't dealt with in 8.1. Michael Glaesemann
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/utils/adt/datetime.c | modified | +29 −15 |
| src/interfaces/ecpg/pgtypeslib/interval.c | modified | +29 −15 |
| src/test/regress/expected/interval.out | modified | +12 −0 |
| src/test/regress/sql/interval.sql | modified | +2 −0 |