Hi all, There have been multiple threads in the past discussing infinite intervals: https://www.postgresql.org/message-id/flat/4EB095C8.1050703%40agliodbs.com https://www.postgresql.org/message-id/flat/200101241913.f0OJDUu45423%40hub.org https://www.postgresql.org/message-id/flat/CANP8%2BjKTxQh4Mj%2BU3mWO3JHYb11SeQX9FW8SENrGbTdVxu6NNA%40mail.gmail.com
As well as an entry in the TODO list: https://wiki.postgresql.org/wiki/Todo#Dates_and_Times However, it doesn't seem like this was ever implemented. Is there still any interest in this feature? If so, I'd like to try and implement it. The proposed design from the most recent thread was to reserve INT32_MAX months for infinity and INT32_MIN months for negative infinity. As pointed out in the thread, these are currently valid non-infinite intervals, but they are out of the documented range. Thanks, Joe Koshakow