Re: Procedure for feature requests?
От | Tim Landscheidt |
---|---|
Тема | Re: Procedure for feature requests? |
Дата | |
Msg-id | m3d44893g3.fsf@passepartout.tim-landscheidt.de обсуждение исходный текст |
Ответ на | Procedure for feature requests? (Tim Landscheidt <tim@tim-landscheidt.de>) |
Ответы |
Re: Procedure for feature requests?
|
Список | pgsql-general |
Sam Mason <sam@samason.me.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
В списке pgsql-general по дате отправления: