Re: How to specify infinity for intervals ?

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to specify infinity for intervals ?
Date: 2006-02-25 06:59:35
Message-ID: 6EFAF3CD-56AF-4177-8FBC-444CDA40B75B@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message chris smith 2006-02-25 09:13:59 Re: Could DBmirror be done with the mechine using RPM installation instaed of souce code [tar.gz] ?
Previous Message Bruce Momjian 2006-02-25 04:49:51 Re: ECPG and COPY