Re: How to specify infinity for intervals ? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: How to specify infinity for intervals ?
Date
Msg-id 200602251634.k1PGYuY25825@candle.pha.pa.us
Whole thread Raw
In response to Re: How to specify infinity for intervals ?  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-general
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. +

pgsql-general by date:

Previous
From: "Natasha Galkina"
Date:
Subject: rotate records
Next
From: Michael Fuhr
Date:
Subject: Re: rotate records