Re: How to specify infinity for intervals ? - Mailing list 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