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