Thread: pgsql: Fix DecodeDateTime to allow timezone to appear before year.

pgsql: Fix DecodeDateTime to allow timezone to appear before year.

From

tgl@postgresql.org (Tom Lane)

Date:

12 June 2007, 15:58:43

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)