Re: Is there a good reason we don't have INTERVAL 'infinity'?

Brar Piening wrote:
> 
> Josh Berkus wrote:
> > Hackers,
> >
> > Is there a reason why INTERVAL 'infinity' is not implemented?  That is,
> > an interval which is larger than all defined intervals, and which added
> > to any timestamp turns it into 'infinity'.
> >
> > Or is it just Round TUITs?
> 
> Probably the latter.
> There is even a function |isfinite(interval)| which doesn't seem to do 
> anything useful.
> See complaint in 
> http://archives.postgresql.org/message-id/200101241913.f0OJDUu45423@hub.org
> Although the operation used in this complaint isn't obviously defined 
> there certainly are operations that are defined like infinity + infinity 
> = infinity.
> See http://de.wikipedia.org/wiki/Unendlichkeit#Analysis
> (Sorry for linking the german wikipedia - the english text is ways less 
> verbose on this.)

TODO has:
Allow infinite intervals just like infinite timestamps 

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +