Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Make to_timestamp and friends skip leading spaces before an - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Make to_timestamp and friends skip leading spaces before an
Date
Msg-id 20090622175430.D0C5E75331E@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
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)

pgsql-committers by date:

Previous
From: bmomjian@pgfoundry.org (User Bmomjian)
Date:
Subject: pg-migrator - pg_migrator: Example improvement.
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: For bulk write operations (eg COPY IN), use a ring buffer of 16MB