postgres.git / summary / log / commit / refs

commit    5d2adf0f81a2e4ca4f101b19b1efea147b462301
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Thu Feb 09 20:49:57 2017 +0000

    Blind try to fix portability issue in commit 8f93bd851 et al.
    
    The S/390 members of the buildfarm are showing failures indicating
    that they're having trouble with the rint() calls I added yesterday.
    There's no good reason for that, and I wonder if it is a compiler bug
    similar to the one we worked around in d9476b838.  Try to fix it using
    the same method as before, namely to store the result of rint() back
    into a "double" variable rather than immediately converting to int64.
    (This isn't entirely waving a dead chicken, since on machines with
    wider-than-double float registers, the extra store forces a width
    conversion.  I don't know if S/390 is like that, but it seems worth
    trying.)
    
    In passing, merge duplicate ereport() calls in float8_timestamptz().
    
    Per buildfarm.


src/backend/utils/adt/timestamp.c | 14 ++++++-------- 1 file changed, 6 insertions(+), 8 deletions(-) diff --git a/src/backend/utils/adt/timestamp.c b/src/backend/utils/adt/timestamp.c index 81b76314de9..9b4c012a63c 100644 --- a/src/backend/utils/adt/timestamp.c +++ b/src/backend/utils/adt/timestamp.c @@ -773,12 +773,8 @@ float8_timestamptz(PG_FUNCTION_ARGS) { /* Out of range? */ if (seconds < - (float8) SECS_PER_DAY * (DATETIME_MIN_JULIAN - UNIX_EPOCH_JDATE)) - ereport(ERROR, - (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE), - errmsg("timestamp out of range: \"%g\"", seconds))); - - if (seconds >= + (float8) SECS_PER_DAY * (DATETIME_MIN_JULIAN - UNIX_EPOCH_JDATE) + || seconds >= (float8) SECS_PER_DAY * (TIMESTAMP_END_JULIAN - UNIX_EPOCH_JDATE)) ereport(ERROR, (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE), @@ -788,7 +784,8 @@ float8_timestamptz(PG_FUNCTION_ARGS) seconds -= ((POSTGRES_EPOCH_JDATE - UNIX_EPOCH_JDATE) * SECS_PER_DAY); #ifdef HAVE_INT64_TIMESTAMP - result = rint(seconds * USECS_PER_SEC); + seconds = rint(seconds * USECS_PER_SEC); + result = (int64) seconds; #else result = seconds; #endif @@ -1624,9 +1621,10 @@ make_interval(PG_FUNCTION_ARGS) result->day = weeks * 7 + days; #ifdef HAVE_INT64_TIMESTAMP + secs = rint(secs * USECS_PER_SEC); result->time = hours * ((int64) SECS_PER_HOUR * USECS_PER_SEC) + mins * ((int64) SECS_PER_MINUTE * USECS_PER_SEC) + - (int64) rint(secs * USECS_PER_SEC); + (int64) secs; #else result->time = hours * (double) SECS_PER_HOUR + mins * (double) SECS_PER_MINUTE + [parent: 806091c96f9b]