Skip site navigation (1) Skip section navigation (2)

pgsql: Properly round months into days and into seconds for interval

From: momjian(at)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Properly round months into days and into seconds for interval
Date: 2006-09-03 03:34:04
Message-ID: 20060903033404.B5CE09FB4B9@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Properly round months into days and into seconds for interval
multiplication/division queries like select '41 mon 10:00:00'::interval
/ 10 as "pos".

Report from Michael Glaesemann

Modified Files:
--------------
    pgsql/src/backend/utils/adt:
        timestamp.c (r1.165 -> r1.166)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c.diff?r1=1.165&r2=1.166)
    pgsql/src/test/regress/expected:
        interval.out (r1.15 -> r1.16)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/interval.out.diff?r1=1.15&r2=1.16)

Responses

pgsql-committers by date

Next:From: Michael GlaesemannDate: 2006-09-03 04:33:19
Subject: Re: pgsql: Properly round months into days and into seconds for interval
Previous:From: Bruce MomjianDate: 2006-09-03 03:26:42
Subject: pgsql: Reverted: < * -Change LIMIT/OFFSET and FETCH/MOVE to use int8 >

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group