Skip site navigation (1) Skip section navigation (2)

Re: How to specify infinity for intervals ?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to specify infinity for intervals ?
Date: 2006-02-25 03:09:25
Message-ID: 200602250309.k1P39PG11065@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
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. +

In response to

Responses

pgsql-general by date

Next:From: Christopher BrowneDate: 2006-02-25 03:38:23
Subject: Re: psql is very slow
Previous:From: Ken WinterDate: 2006-02-25 02:25:26
Subject: Another perplexity with PG rules

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group