Make to_timestamp and friends skip leading spaces before an integer field,
authorTom Lane <[email protected]>
Mon, 22 Jun 2009 17:54:30 +0000 (17:54 +0000)
committerTom Lane <[email protected]>
Mon, 22 Jun 2009 17:54:30 +0000 (17:54 +0000)
commitb20155d50f979392c60519d4a88a0984adb28b4e
treef31068c6149978c5f9165e6974468c6300c7bc8f
parente5b606640811b9a981d437a160b300b8813d3254
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