Skip site navigation (1) Skip section navigation (2)

BUG #6220: Flagstaff

From: "Nicolas Beuzeboc" <nicolasbeuzeboc(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6220: Flagstaff
Date: 2011-09-23 18:49:09
Message-ID: 201109231849.p8NIn9LH006193@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      6220
Logged by:          Nicolas Beuzeboc
Email address:      nicolasbeuzeboc(at)gmail(dot)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)

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-09-24 02:16:25
Subject: Re: Timezone issues with Postrres
Previous:From: Marcin MańkDate: 2011-09-23 17:35:48
Subject: Re: [v9.2] make_greater_string() does not return a string in some cases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group