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

From Greg Stark
Subject Re: numeric and float converts to int differently?
Date
Msg-id 87brs1gr4y.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: numeric and float converts to int differently?  ("SZŰCS Gábor" <surrano@mailbox.hu>)
List pgsql-sql
"SZÛCS Gábor" <surrano@mailbox.hu> writes:

> > cannot see is that the float values are not actually exactly 0.5
> 
> Yes I could guess that (floating point vs fixed), but is this a coincidence
> that both '0.5'::float and '-0.5'::float are closer to 0, whereas they could
> be closer to +/-1, as well as both closer to the lower or upper bound.

Wouldn't 0.5 and -0.5 be representable exactly as floats?


-- 
greg



pgsql-sql by date:

Previous
From: SZUCS Gábor
Date:
Subject: Re: URGENT!!! changing Column size
Next
From: SZUCS Gábor
Date:
Subject: Re: numeric and float converts to int differently?