Re: [BUGS] float conversion / presentation problem ?

2005-04-07 Thread Enrico Weigelt
* Tom Lane <[EMAIL PROTECTED]> wrote: > Enrico Weigelt <[EMAIL PROTECTED]> writes: > > i've noticed an problem with conversion from real to float - > > this produces ugly values. (in fact it seems to be real->float8) > > You do realize that float4/real is only good to six decimal places > on most

Re: [BUGS] float conversion / presentation problem ?

2005-04-07 Thread David Fetter
On Thu, Apr 07, 2005 at 01:02:50AM -0400, Tom Lane wrote: > John R Pierce <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> You do realize that float4/real is only good to six decimal > >> places on most platforms? > > > and importantly, are stored as binary fractions. 0.1 decimal > > is a