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

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 (view raw or flat)
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

pgsql-general by date

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

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