Thread: how to make infinite intervals?
I see there is a isfinite(interval) function. So there must be something like a infinite interval. An infinite interval would be yuite handy for me at the moment. But i have no clue how to make one. interval 'infinity' does not do the trick. :) Thank you -- Tilman Baumann Software Developer Collax GmbH . Boetzinger Straße 60 . 79111 Freiburg . Germany p: +49 (0) 761-4514-836 f: +49 (0) 761-4563-793 ****** Meet us at CeBIT ****** LinuxPark, Halle 5, Stand E64/6
Tilman Baumann wrote: > I see there is a isfinite(interval) function. So there must be something > like a infinite interval. > > An infinite interval would be yuite handy for me at the moment. But i > have no clue how to make one. > > interval 'infinity' does not do the trick. :) On the TODO list: o Allow infinite dates and intervals just like infinite timestamps -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. +
Bruce Momjian schrieb: <blockquote cite="mid200603031713.k23HDN528440@candle.pha.pa.us" type="cite"><pre wrap="">TilmanBaumann wrote: </pre><blockquote type="cite"><pre wrap="">I see there is a isfinite(interval) function. Sothere must be something like a infinite interval. An infinite interval would be yuite handy for me at the moment. But i have no clue how to make one. interval 'infinity' does not do the trick. :) </pre></blockquote><pre wrap=""> On the TODO list: o Allow infinite dates and intervals just like infinite timestamps </pre></blockquote> Oh, i see.<br /> Well, i can livewithout. :) Looking forward...<br /><br /><pre class="moz-signature" cols="72">-- Tilman Baumann Software Developer Collax GmbH . Boetzinger Straße 60 . 79111 Freiburg . Germany p: +49 (0) 761-4514-836 f: +49 (0) 761-4563-793 ****** Meet us at CeBIT ****** LinuxPark, Halle 5, Stand E64/6 </pre>
Tilman Baumann <tilman.baumann@collax.com> writes: > I see there is a isfinite(interval) function. Looks like it's just a stub :-( Datum interval_finite(PG_FUNCTION_ARGS) {PG_RETURN_BOOL(true); } Evidently someone planned for infinite intervals a long time ago, but never got round to it. regards, tom lane