yes, MAJOR goof on my part. My brain cells were not firing quite right :( For those really interested, here are some resources: http://www.cs.wisc.edu/~cs354-1/cs354/karen.notes/reps.flpt.html http://cch.loria.fr/documentation/IEEE754/ACM/goldberg.pdf http://babbage.cs.qc.edu/courses/cs341/IEEE-754references.html
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Tom Lane > Sent: Friday, November 04, 2005 11:52 AM > To: [EMAIL PROTECTED] > Cc: pgsql-hackers@postgresql.org > Subject: Re: [OT] somebody could explain this? > > > "Otto Hirr" <[EMAIL PROTECTED]> writes: > > Most notably, the IEEE rep, either single or double, most certainly > > has the ability to store the EXACT value for 0.1. > > Oh really? > > regards, tom lane > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend