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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-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

Browse pgsql-bugs by date

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

Browse pgsql-patches by date

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