pgsql: Make to_timestamp and friends skip leading spaces before an

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Make to_timestamp and friends skip leading spaces before an
Date: 2009-06-22 17:54:30
Message-ID: 20090622175430.D0C5E75331E@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Make to_timestamp and friends skip leading spaces before an integer field,
even when not in FM mode. This improves compatibility with Oracle and with
our pre-8.4 behavior, as per bug #4862.

Brendan Jurd

Add a couple of regression test cases for this. In passing, get rid of the
labeling of the individual test cases; doesn't seem to be good for anything
except causing extra work when inserting a test...

Tom Lane

Modified Files:
--------------
pgsql/src/backend/utils/adt:
formatting.c (r1.157 -> r1.158)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/formatting.c?r1=1.157&r2=1.158)
pgsql/src/test/regress/expected:
horology.out (r1.70 -> r1.71)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/horology.out?r1=1.70&r2=1.71)
pgsql/src/test/regress/sql:
horology.sql (r1.36 -> r1.37)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/horology.sql?r1=1.36&r2=1.37)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2009-06-22 20:04:28 pgsql: For bulk write operations (eg COPY IN), use a ring buffer of 16MB
Previous Message User Bmomjian 2009-06-22 13:19:53 pg-migrator - pg_migrator: Example improvement.