Обсуждение: pgsql: Make to_timestamp and friends skip leading spaces before an

Поиск
Список
Период
Сортировка

pgsql: Make to_timestamp and friends skip leading spaces before an

От
tgl@postgresql.org (Tom Lane)
Дата:
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)