Tom Lane 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 platforms?

You can take the issue up with the glibc boys if you like, but
I think you'll get laughed off.

and importantly, are stored as binary fractions. 0.10000 decimal is a repeating fraction in binary, its like .1100110011.... x 2^-2 or something as a FLOAT. Float4 has like 22 bits of significants for the mantissa, while Float8 has like 51 bits or something (this is from rusty memory, so I could have slipped a few bits here).


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Reply via email to