Re: numeric and float converts to int differently? - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: numeric and float converts to int differently?
Date
Msg-id 20031028203119.GB14260@wolff.to
Whole thread Raw
In response to Re: numeric and float converts to int differently?  (SZUCS Gábor <surrano@mailbox.hu>)
List pgsql-sql
On Tue, Oct 28, 2003 at 21:16:53 +0100, SZUCS Gábor <surrano@mailbox.hu> wrote:
> 
> As Tom pointed out, it isn't a floating point failure -- it is how rounding
> float is implemented. I assume anything with less than 15 digits can be
> exactly represented as float.

No. It has to be a dyadic number. For example .3 will not be represented
exactly by a float.


pgsql-sql by date:

Previous
From: SZUCS Gábor
Date:
Subject: Re: numeric and float converts to int differently?
Next
From: Christopher Browne
Date:
Subject: Re: numeric and float converts to int differently?