Thread: pgsql: Fix parsing of time string followed by yesterday/today/tomorrow.

pgsql: Fix parsing of time string followed by yesterday/today/tomorrow.

From
Robert Haas
Date:
Fix parsing of time string followed by yesterday/today/tomorrow.

Previously, 'yesterday 04:00:00'::timestamp didn't do the same thing as
'04:00:00 yesterday'::timestamp, and the return value from the latter
was midnight rather than the specified time.

Dean Rasheed, with some stylistic changes

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/8a3d33c8e6c681d512f79af4a521ee0c02befcef

Modified Files
--------------
src/backend/utils/adt/datetime.c       |   23 ++++------
src/test/regress/expected/horology.out |   78 ++++++++++++++++++++++++++++++++
src/test/regress/sql/horology.sql      |   13 +++++
3 files changed, 100 insertions(+), 14 deletions(-)