Re: How to specify infinity for intervals ?

OK, added to TODO.

---------------------------------------------------------------------------

Michael Glaesemann wrote:
>
> On Feb 25, 2006, at 12:09 , Bruce Momjian wrote:
>
> > We have this TODO:
> >
> >         o Allow infinite dates just like infinite timestamps
> >
> > Do we need to add intervals to this?
>
> I think to be consistent with the other datetime types, might as
> well. Then one would be able to get an answer to
>
> test=# select 'infinity'::timestamp - current_timestamp;
> ERROR:  cannot subtract infinite timestamps
>
> Michael Glaesemann
> grzm myrealbox com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>

--
  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. +