Re: Re: Updated interval patches (SQL std output, ISO8601 intervals, and interval rounding)

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>, Brendan Jurd <direvus(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: Updated interval patches (SQL std output, ISO8601 intervals, and interval rounding)
Date: 2008-11-12 01:53:41
Message-ID: 491A3725.3050700@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> The original INT64 coding here is exact (at least for the common case
> where fval is zero) but I'm not convinced that your revision can't
> suffer from roundoff error.

Good point. I'll study this tonight; and either try to make a patch
that'll be exact where fval's zero or try to come up with convincing
reasons that it's harmless.

Once this settles I suppose I should post a ECPG patch that's based
off of these Decode/Encode interval functions too?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-11-12 01:59:19 Re: Re: Updated interval patches (SQL std output, ISO8601 intervals, and interval rounding)
Previous Message Unicron 2008-11-12 01:47:05 Result for "Automatically update view"