| From: | Brendan Jurd <direvus(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Gregory Stark <stark(at)enterprisedb(dot)com>, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [BUGS] BUG #4660: float functions return -0 |
| Date: | 2009-02-17 19:24:28 |
| Message-ID: | 37ed240d0902171124x2cbebd9dq9af320083dcb7e34@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Wed, Feb 18, 2009 at 2:57 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> The point I'm trying to make is that we should deliver IEEE-compliant
> results if we are on a platform that complies with the spec. Right down
> to the minus sign. If that surprises people who are unfamiliar with the
> spec, well, there are a lot of things about floating point arithmetic
> that surprise people who aren't familiar with it.
Agreed. There are plenty of things about floats that are downright
wonky, and when people start seeing minus zero in their float
computations it might prompt them into doing some reading, and
figuring out that what they really wanted was numeric.
(not saying that floats are without application, but I've often
encountered them in places they ought not to be)
Cheers,
BJ
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-02-18 01:34:45 | Re: [BUGS] BUG #4660: float functions return -0 |
| Previous Message | Tom Lane | 2009-02-17 15:57:58 | Re: [BUGS] BUG #4660: float functions return -0 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Teodor Sigaev | 2009-02-17 19:28:58 | GIN fast insert |
| Previous Message | David Fetter | 2009-02-17 17:55:02 | Re: Good Delimiter for copy command |