| From: | "Traci Sumpter" <traci(dot)sumpter(at)opus(dot)com(dot)au> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #4514: Pi division error |
| Date: | 2008-11-06 06:56:07 |
| Message-ID: | 200811060656.mA66u75N055551@wwwmaster.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4514
Logged by: Traci Sumpter
Email address: traci(dot)sumpter(at)opus(dot)com(dot)au
PostgreSQL version: 8.3.3
Operating system: Linux
Description: Pi division error
Details:
I am trying to do some calculations within Postgresql and am not getting the
expected result. the first set proves that the pi works as expected with
multiplication.
Equation 180*pi
VB 565.486677646163
Calculator 565.486677646163
PostgreSQL 565.486677646163
Php 565.48667764616
However if I extend this equation postgres definately fails this test.
Equation (315-0)/180*pi
VB 5.49778714378213
Calculator 5.497787144
PostgreSQL 3.14159265358979
Php 5.4977871437821
Help
| From | Date | Subject | |
|---|---|---|---|
| Next Message | xtron | 2008-11-06 12:05:23 | BUG #4515: UPDATE strange behavior |
| Previous Message | Alex Hunsaker | 2008-11-06 02:30:05 | Re: plperl & sort |