[BUGS] BUG #6290: converting interval from weeks to days

2011-11-10 Thread Alexey Nalbat
The following bug has been logged online: Bug reference: 6290 Logged by: Alexey Nalbat Email address: alexey_nal...@hotbox.ru PostgreSQL version: 9.1.1 Operating system: Ubuntu Description:converting interval from weeks to days Details: = select '10

Re: [BUGS] BUG #6290: converting interval from weeks to days

2011-11-10 Thread John R Pierce
On 11/10/11 1:15 PM, Alexey Nalbat wrote: = select '10 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

Re: [BUGS] BUG #6290: converting interval from weeks to days

2011-11-10 Thread Craig Ringer
On 11/11/2011 09:35 AM, John R Pierce wrote: On 11/10/11 1:15 PM, Alexey Nalbat wrote: = select '10 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