pgsql: Fix a bug in input processing for the "interval" type.

Lists: pgsql-committers
From: neilc(at)postgresql(dot)org (Neil Conway)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix a bug in input processing for the "interval" type.
Date: 2007-05-29 04:59:15
Message-ID: 20070529045915.6F0809FB792@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-committers

Log Message:
-----------
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

Tags:
----
REL8_2_STABLE

Modified Files:
--------------
pgsql/doc/src/sgml:
datatype.sgml (r1.181.2.2 -> r1.181.2.3)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/datatype.sgml.diff?r1=1.181.2.2&r2=1.181.2.3)
pgsql/src/backend/utils/adt:
datetime.c (r1.174 -> r1.174.2.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c.diff?r1=1.174&r2=1.174.2.1)
pgsql/src/include/utils:
datetime.h (r1.62 -> r1.62.2.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/datetime.h.diff?r1=1.62&r2=1.62.2.1)
pgsql/src/test/regress/expected:
interval.out (r1.18 -> r1.18.2.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/interval.out.diff?r1=1.18&r2=1.18.2.1)
pgsql/src/test/regress/sql:
interval.sql (r1.11 -> r1.11.2.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/interval.sql.diff?r1=1.11&r2=1.11.2.1)