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

Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps

From: Oliver Siegmar <oliver(at)siegmar(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps
Date: 2005-04-21 07:10:02
Message-ID: 200504210910.02696.oliver@siegmar.net (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
> I've applied this patch.

It removed the bug, but also added a new one (hopefully only one ;-))


...now with ISO DateStyle -


select '2005 years 4 mons 20 days 15 hours 57 mins 12.1 secs ago'::interval;


Before your patch:

                 interval
-------------------------------------------
 -2005 years -4 mons -20 days -15:57:12.10
(1 row)



after applying your patch:

                     interval
---------------------------------------------------
 -2005 years -4 mons -20 days -15:57:12.1000000001
(1 row)




Oliver

Responses

pgsql-bugs by date

Next:From: Olleg SamoylovDate: 2005-04-21 12:19:44
Subject: BUG #1610: rewrite rule and sequence
Previous:From: Tom LaneDate: 2005-04-20 20:25:45
Subject: Re: BUG #1608: integer negative limit in plpgsql function arguments

pgsql-patches by date

Next:From: Qingqing ZhouDate: 2005-04-21 10:12:03
Subject: revise a comment in CreateCheckPoint()
Previous:From: Simon RiggsDate: 2005-04-20 16:05:55
Subject: Re: COPY Fillfactor patch

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