pgsql: Fix interval division and multiplication, before: test=> select

From: momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix interval division and multiplication, before: test=> select
Date: 2005-07-20 03:50:24
Message-ID: 20050720035024.EF82452849@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Fix interval division and multiplication, before:

test=> select '4 months'::interval / 5;
?column?
---------------
1 mon -6 days
(1 row)

after:

test=> select '4 months'::interval / 5;
?column?
----------
24 days
(1 row)

The problem was the use of rint() to round, and then find the remainder,
causing the negative values.

Modified Files:
--------------
pgsql/src/backend/utils/adt:
timestamp.c (r1.132 -> r1.133)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c.diff?r1=1.132&r2=1.133)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2005-07-20 16:42:32 pgsql: Add 'day' field to INTERVAL so 1 day interval can be
Previous Message User Jzhang 2005-07-19 23:11:35 bizgres - bizgres: Check in the code for the bitmap scan.