| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Shachar Shemesh <shachar(at)shemesh(dot)biz> |
| Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org, Greg Smith <gsmith(at)gregsmith(dot)com>, oledb-devel(at)pgfoundry(dot)org |
| Subject: | Re: Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server |
| Date: | 2007-05-24 06:04:12 |
| Message-ID: | 28873.1179986652@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Shachar Shemesh <shachar(at)shemesh(dot)biz> writes:
> Tom Lane wrote:
>> I seem to recall also that there are machines that
>> treat the exponent as power-of-16 not power-of-2.
> I'm pretty sure I don't understand this. Maybe I misunderstood the
> format, but wouldn't that actually lose you precision with, at most,
> marginal gain in range?
I didn't say it was *better*, only that it was *different*.
Some marginal googling suggests that only IBM made this choice, and that
they now (thirty-some years later) concede the IEEE format is better.
Still, if we're running on s/390 hardware ... or ARM, or whatever ...
it behooves us not to lose data. I'm fine with doing byte-swapping to
present a uniform face for platforms that are at bottom implementing the
same FP format; but I've got a problem with trying to force
noncompatible platforms into that format.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tasneem Memon | 2007-05-24 13:43:24 | Help Required regarding implementing operators in postgreSQL |
| Previous Message | Shachar Shemesh | 2007-05-24 05:24:58 | Re: Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server |