Re: infinity interval - Mailing list pgsql-general

From Bruce Momjian
Subject Re: infinity interval
Date
Msg-id 200812210330.mBL3UTH11436@momjian.us
Whole thread Raw
In response to infinity interval  (Gerhard Heift <ml-postgresql-20081012-3518@gheift.de>)
List pgsql-general
Gerhard Heift wrote:
> how can I store an infinity value into an interval? I want to store
> offsets to a timestamp, and for some cases i need +infinity and
> -infinity as result.
>
> I want to make something like this:
> SELECT now() + 'infinity'::interval;
>
> This should return 'infinity'::timestamp.
>
> Is it possible?

TODO has:

    o Allow infinite intervals just like infinite timestamps

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-general by date:

Previous
From: Martin Gainty
Date:
Subject: Re: infinity interval
Next
From: Herouth Maoz
Date:
Subject: Re: Copy/delete issue