Chapman Flack <c...@anastigmatix.net> writes: > On 12/13/18 04:41, Simon Riggs wrote: >> [ we should allow this: ] >> 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, That wouldn't be optional. All built-in functions on interval would *have* to be updated to deal sanely with the new values. (Fortunately, there aren't that many of them, IIRC.) regards, tom lane