Обсуждение: pgsql: Properly round months into days and into seconds for interval

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)

On Sep 3, 2006, at 12:34 , Bruce Momjian wrote:

> 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

Actually it was reported by Michael Paesold

http://archives.postgresql.org/pgsql-hackers/2005-11/msg00254.php

I just attempted to fix it.

Michael Glaesemann
grzm seespotcode net