pgsql: Fix DecodeDateTime to allow timezone to appear before year. - Mailing list pgsql-committers

Log Message:
-----------
Fix DecodeDateTime to allow timezone to appear before year.  This had
historically worked in some but not all cases, but as of 8.2 it failed for all
timezone formats.  Fix, and add regression test cases to catch future
regressions in this area.  Per gripe from Adam Witney.

Tags:
----
REL8_2_STABLE

Modified Files:
--------------
    pgsql/src/backend/utils/adt:
        datetime.c (r1.174.2.1 -> r1.174.2.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c.diff?r1=1.174.2.1&r2=1.174.2.2)
    pgsql/src/test/regress/expected:
        timestamptz.out (r1.21.2.1 -> r1.21.2.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/timestamptz.out.diff?r1=1.21.2.1&r2=1.21.2.2)
    pgsql/src/test/regress/sql:
        timestamptz.sql (r1.10 -> r1.10.2.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/timestamptz.sql.diff?r1=1.10&r2=1.10.2.1)