pgsql: Use floor() not rint() when reducing precision of fractional - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Use floor() not rint() when reducing precision of fractional
Date
Msg-id 20090706202923.9324575331E@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Use floor() not rint() when reducing precision of fractional seconds in
timestamp_trunc, timestamptz_trunc, and interval_trunc().  This change
only affects the float-datetime case; the integer-datetime case already
behaved like truncation instead of rounding.  Per gripe from Mario Splivalo.

This is a pre-existing issue but I'm choosing not to backpatch, because
it's such a corner case and there have not been prior complaints.  The
issue is largely moot anyway given the trend towards integer datetimes.

Modified Files:
--------------
    pgsql/src/backend/utils/adt:
        timestamp.c (r1.201 -> r1.202)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c?r1=1.201&r2=1.202)

pgsql-committers by date:

Previous
From: heikki@postgresql.org (Heikki Linnakangas)
Date:
Subject: pgsql: Fix ancient bug in handling of to_char modifier 'TH', when used
Next
From: jbcooley@pgfoundry.org (User Jbcooley)
Date:
Subject: npgsql - Npgsql2: Share NumberFormatInfo between regular value