From: | Tim Landscheidt <tim(at)tim-landscheidt(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Procedure for feature requests? |
Date: | 2009-10-27 17:01:00 |
Message-ID: | m3d44893g3.fsf@passepartout.tim-landscheidt.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sam Mason <sam(at)samason(dot)me(dot)uk> wrote:
> [...]
>> I would assume
>> that you just have to convert A, B and C to seconds (since
>> epoch) and then use a normal integer division.
> The problem is that the Gregorian calender is far too complicated. For
> example, think what would happen with an interval of "months". It
> doesn't help converting to seconds because the length of a month in
> seconds changes depending on which year the month is in and which
> month you're actually dealing with. This makes any definition of
> "division" I've ever been able to think of ill defined and hence the
> above calculation won't work.
Yep, you would probably need some safety margin and add a
"WHERE" clause. I should have thought about that earlier as
I recently stumbled (again) over why "INTERVAL / INTERVAL"
was not defined.
Tim
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2009-10-27 17:06:03 | Re: Procedure for feature requests? |
Previous Message | Pavel Stehule | 2009-10-27 16:35:04 | Re: Upgrade from 8.2 to 8.3 & catching errors in functions |