Re: Procedure for feature requests?

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

In response to

Responses

Browse pgsql-general by date

  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