On 12/13/18 04:41, Simon Riggs wrote: > SELECT 'infinity'::timestamp; > works > > SELECT 'infinity'::interval; > ERROR: invalid input syntax for type interval: "infinity"
... and if that is made to work, perhaps then arithmetic should be updated as well, with this producing an infinite interval result: SELECT timestamptz 'infinity' - current_timestamp; ERROR: cannot subtract infinite timestamps ISO (2011 draft) seems to have nothing to say about infinity, for datetimes or intervals. -Chap
