OSDN Git Service

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)
commit57bfb27e60055c10e42b87e68a894720c2f78e70
treeae27e5eb9686177b0668385abe023a169e656227
parent091fe037757abbecd6994daea0ae4eaa87f7217e
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