Re: [PATCHES] [BUGS] BUG #2846: inconsistent and confusing handling - Mailing list pgsql-patches

From Roman Kononov
Subject Re: [PATCHES] [BUGS] BUG #2846: inconsistent and confusing handling
Date
Msg-id 4592D71E.8070401@yahoo.com
Whole thread Raw
In response to Re: [BUGS] BUG #2846: inconsistent and confusing handling of  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
On 12/27/2006 01:15 PM, Tom Lane wrote:
> I'm not convinced that you're fixing things so much as doing your best
> to destroy IEEE-compliant float arithmetic behavior.
>
> I think what we should probably consider is removing CheckFloat4Val
> and CheckFloat8Val altogether, and just letting the float arithmetic
> have its head.  Most modern hardware gets float arithmetic right per
> spec, and we shouldn't be second-guessing it.

I vote for complete IEEE-compliance. No exceptions with pure floating
point math. Float -> int conversions should reject overflow, INF and
NaN. Float -> numeric conversions should reject INF.

> A slightly less radical proposal is to reject only the case where
> isinf(result) and neither input isinf(); and perhaps likewise with
> respect to NaNs.

This might look like another possibility for confusion. For example
INF-INF=NaN.

Regards,
Roman.



pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] unprivileged contrib and pl install (formerly tsearch
Next
From: Jeremy Drake
Date:
Subject: Re: [HACKERS] unprivileged contrib and pl install