The following bug has been logged online:
Bug reference: 6220
Logged by: Nicolas Beuzeboc
Email address: nicolasbeuzeboc@gmail.com
PostgreSQL version: 8.4.8
Operating system: Ubuntu Natty
Description: Flagstaff
Details:
There is a month difference between the query results
it's not happening if I take the 7.4999.. number and multiply it by interval
'1 year'
psql (8.4.8)
Type "help" for help.
postgres=# select now() - interval '7.5 years', now()- interval
'7.4999999999999999 year', now() - interval '7.49999999999999999 years';
?column? | ?column? |
?column?
-------------------------------+-------------------------------+------------
-------------------
2004-03-23 11:44:30.980895-07 | 2004-04-23 11:44:30.980895-07 | 2004-03-23
11:44:30.980895-07
(1 row)
postgres=# select version();
version
----------------------------------------------------------------------------
----------------------------------------
PostgreSQL 8.4.8 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.5.real
(Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 64-bit
(1 row)