Thread: pgsql: Clean up a couple of weird corner cases in interval parsing: make

pgsql: Clean up a couple of weird corner cases in interval parsing: make

From

tgl@postgresql.org (Tom Lane)

Date:

16 September 2008, 22:31:27

Log Message:
-----------
Clean up a couple of weird corner cases in interval parsing: make -yyyy-mm be
interpreted as expected (the sign should affect months too), and get rid of
hard-wired assumption that unmarked signed values must be hours (if integers)
or seconds (if floats).  The former was just a bug in my previous patch,
while the latter may have made sense at one time but seems illogical now
that we support determination of the units from typmod information.
Ron Mayer and myself.

Modified Files:
--------------
    pgsql/src/backend/utils/adt:
        datetime.c (r1.192 -> r1.193)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c?r1=1.192&r2=1.193)
    pgsql/src/test/regress/expected:
        interval.out (r1.22 -> r1.23)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/interval.out?r1=1.22&r2=1.23)
    pgsql/src/test/regress/sql:
        interval.sql (r1.14 -> r1.15)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/interval.sql?r1=1.14&r2=1.15)