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 days
>
> a 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