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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
