Postgres Pro
Downloads
Home   >   mailing lists

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 200602250309.k1P39PG11065@candle.pha.pa.us
Whole thread Raw
In response to Re: How to specify infinity for intervals ?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: How to specify infinity for intervals ?  (Michael Glaesemann <grzm@myrealbox.com>)
Re: How to specify infinity for intervals ?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Tree view 
Karsten Hilbert wrote:
> Thanks to all for the suggestions.
>
> For the time being I will stay with using NULL.
>
> I will also stay with the hope that one day before long we
> will have "'infinite'::interval".

We have this TODO:

        o Allow infinite dates just like infinite timestamps

Do we need to add intervals to this?

--
  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: "Ken Winter"
Date:
Subject: Another perplexity with PG rules
Next
From: Christopher Browne
Date:
Subject: Re: psql is very slow