| From: | Joseph Koshakow <koshy44(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Infinite Interval |
| Date: | 2022-12-10 19:21:12 |
| Message-ID: | CAAvxfHea4+sPybKK7agDYOMo9N-Z3J6ZXf3BOM79pFsFNcRjwA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2022-12-10 19:38:38 | Re: Error-safe user functions |
| Previous Message | Corey Huinker | 2022-12-10 17:19:59 | Re: Error-safe user functions |