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

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: momjian(at)postgresql(dot)org (Bruce Momjian)
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Properly round months into days and into seconds for interval
Date: 2006-09-03 04:33:19
Message-ID: B9838A98-0F56-414B-9932-CB79CEDDF2F0@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers


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

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2006-09-03 04:49:41 Re: [HACKERS] [COMMITTERS] pgsql: Change FETCH/MOVE to use int8.
Previous Message Bruce Momjian 2006-09-03 03:34:04 pgsql: Properly round months into days and into seconds for interval