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

From Tom Lane
Subject Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps
Date
Msg-id 15529.1114096208@sss.pgh.pa.us
Whole thread Raw
In response to Re: 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
Oliver Siegmar <oliver@siegmar.net> writes:
> On Thursday 21 April 2005 15:57, Tom Lane wrote:
>> If it is only the float case, some imprecision is to be expected.

> So everything is okay?

Well, it's not necessarily *wrong*, but maybe we could improve it.
The code currently assumes it can print 10 fractional digits in the
float case, which is overly optimistic once you get a large number
of days in the "days" component.  Maybe we should add some code
to back off the precision depending on the number of days?

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Marc Soleda"
Date:
Subject: BUG #1612: Problem with PGAPI_SetPos
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps