BUG #6290: converting interval from weeks to days
The following bug has been logged online:
Bug reference: 6290
Logged by: Alexey Nalbat
Email address: alexey_nalbat@hotbox.ru
PostgreSQL version: 9.1.1
Operating system: Ubuntu
Description: converting interval from weeks to days
Details:
=> select '1000000000 weeks'::interval;
interval
------------------
-1589934592 days
(1 row)
On 11/10/11 1:15 PM, Alexey Nalbat wrote:
=> select '1000000000 weeks'::interval;
interval
------------------
-1589934592 days
a billion weeks is like 19 million years. somehow, I don't think that
postgresql's date math has quite that range.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
On 11/11/2011 09:35 AM, John R Pierce wrote:
On 11/10/11 1:15 PM, Alexey Nalbat wrote:
=> select '1000000000 weeks'::interval;
interval
------------------
-1589934592 daysa billion weeks is like 19 million years. somehow, I don't think that
postgresql's date math has quite that range.
It should probably detect overflow and fail with an error like Pg does
with other overflow conditions, though. I think that was probably the point.
--
Craig Ringer