Postgres Pro
Downloads
Home   >   mailing lists

'infinity'::Interval should be added - Mailing list pgsql-hackers

From Simon Riggs
Subject 'infinity'::Interval should be added
Date
Msg-id CANP8+jKTxQh4Mj+U3mWO3JHYb11SeQX9FW8SENrGbTdVxu6NNA@mail.gmail.com
Whole thread Raw
Responses Re: 'infinity'::Interval should be added  (Chapman Flack <chap@anastigmatix.net>)
Re: 'infinity'::Interval should be added  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view
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/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Row Visibility and Table Access Methods
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: allow online change primary_conninfo