infinity interval - Mailing list pgsql-general

From Gerhard Heift
Subject infinity interval
Date
Msg-id 20081220235204.GA15685@kawo1.rwth-aachen.de
Whole thread Raw
Responses Re: infinity interval
Re: infinity interval
Re: infinity interval
List 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

Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Custom Type Alignment
Next
From: "Richard Broersma"
Date:
Subject: Re: infinity interval