At present we have a timestamp of 'infinity' and infinite ranges, but no
infinite interval
SELECT 'infinity'::timestamp;
works
SELECT 'infinity'::interval;
ERROR: invalid input syntax for type interval: "infinity"
Seems a strange anomaly that we should fix.
--
Simon Riggs http://www.2ndQuadrant.com/
<http://www.2ndquadrant.com/>
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services