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.f0ojduu45...@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 <br...@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
