Обсуждение: 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