infinity interval

From: Gerhard Heift <ml-postgresql-20081012-3518(at)gheift(dot)de>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: infinity interval
Date: 2008-12-20 23:52:04
Message-ID: 20081220235204.GA15685@kawo1.rwth-aachen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

how can I store an infinity value into an interval? I want to store
offsets to a timestamp, and for some cases i need +infinity and
-infinity as result.

I want to make something like this:
SELECT now() + 'infinity'::interval;

This should return 'infinity'::timestamp.

Is it possible?

Thanks,
Gerhard

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma 2008-12-21 01:26:29 Re: infinity interval
Previous Message Tom Lane 2008-12-20 21:47:40 Re: Custom Type Alignment