]> granicus.if.org Git - postgresql/commit
Fix INTERVAL output when year/month has different sign as day/hour etc.
authorThomas G. Lockhart <lockhart@fourpalms.org>
Mon, 6 Nov 2000 15:57:00 +0000 (15:57 +0000)
committerThomas G. Lockhart <lockhart@fourpalms.org>
Mon, 6 Nov 2000 15:57:00 +0000 (15:57 +0000)
commit2cf1642461536d0d8f3a1cf124ead0eac04eb760
tree2722d9209e289ea8688fc3c956e8fb9ccff89a67
parentdf9462ac052a63a87d0999fa26f78c6893e5b687
Fix INTERVAL output when year/month has different sign as day/hour etc.
 Previously, all fields were unsigned, with only a trailing "ago" to
 indicate negative intervals. Now, ISO format does not use "ago", and
 and the traditional PostgreSQL format has the first numeric field unsigned
 with "ago" supporting that field. So "1 month - 2 days ago" is two days
 less than a month in the past.
Fix interval arithmetic across daylight savings time boundaries.
 Previously, most math across boundaries introduced a one hour offset.
Allow some date/time functions to return NULL if called with NULL args.
Implement functions for AT TIME ZONE support.
Support "SAT" as an Australian time zone if USE_AUSTRALIAN_RULES
 is defined.
src/backend/utils/adt/datetime.c
src/backend/utils/adt/timestamp.c