Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps - Mailing list pgsql-bugs

From Oliver Siegmar
Subject Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps
Date
Msg-id 200504210910.02696.oliver@siegmar.net
Whole thread Raw
In response to BUG #1609: Bug in interval datatype for 64 Bit timestamps  ("Oliver Siegmar" <oliver@siegmar.net>)
Responses Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps
List pgsql-bugs
> 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

pgsql-bugs by date:

Previous
From: "Ingolf Knopf"
Date:
Subject: BUG #1611: reading a date-field by "ResultSet.getTimestamp()" method analized dayligth flag
Next
From: Tom Lane
Date:
Subject: Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps