]> granicus.if.org Git - postgresql/commit
Make to_timestamp and friends skip leading spaces before an integer field,
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 22 Jun 2009 17:54:30 +0000 (17:54 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 22 Jun 2009 17:54:30 +0000 (17:54 +0000)
commit3f1e529e7897a307ff3431a06b739fa7069d792b
tree207313375aaf7a236fe2b4ca0bcdaba752b2e8a7
parent18df0ffbd2e3a8f93640431f12235a6714785755
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
src/backend/utils/adt/formatting.c
src/test/regress/expected/horology.out
src/test/regress/sql/horology.sql