[GENERAL] Which is best, timestamp as float or integer ?

2009-02-04 Thread A B
Hi. From the manual I read that timestamps are stored as double but they can also be stored as 8 byte integers. I understand the precision problem with floats and the limited range of the integers and I feel confident that I should not worry about the Year 294276 or Year 5874897 problems (highest

Re: [GENERAL] Which is best, timestamp as float or integer ?

2009-02-04 Thread Peter Eisentraut
On Wednesday 04 February 2009 15:48:41 A B wrote: From the manual I read that timestamps are stored as double but they can also be stored as 8 byte integers. The advantage of the integer storage is mainly that calculations and comparisons have a predictable error and don't suffer from some of