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