Re: BUG #4514: Pi division error

Traci Sumpter escribió:
> 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
>
>
hola el problema que entero/entero = entero
lo que debes hacer es

(315.0-0)/180*pi

saludos Fernando