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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +