Sam Mason <s...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
