On Tue, Oct 27, 2009 at 05:01:00PM +0000, Tim Landscheidt wrote: > Sam Mason <sam@xxxxxxxxxxxxx> wrote: > > any definition of "division" I've ever been able to think of [is] > > ill defined > > 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. Not sure what you mean by a "safety margin", but I don't think it would help much. Hours are defined using seconds (they're *always* 3600 seconds long, but, say, a day isn't *always* 24 hours long) so I don't see what a safety margin would do. -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
