Fix interval input parser so that fractional weeks and months are
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 4 Sep 2006 01:26:28 +0000 (01:26 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 4 Sep 2006 01:26:28 +0000 (01:26 +0000)
commit6c547f79a91554960aa08ea978d4da8b0637581b
treecf525e5b46686c7b84c6b3f6cc677820913823a9
parentd4e9961a1d2b3492177a468e571e0b10861dff2c
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
src/backend/utils/adt/datetime.c
src/interfaces/ecpg/pgtypeslib/interval.c
src/test/regress/expected/interval.out
src/test/regress/sql/interval.sql