Re: BUG #4514: Pi division error - Mailing list pgsql-bugs

Traci Sumpter escribió:
> The following bug has been logged online:
>
> Bug reference:      4514
> Logged by:          Traci Sumpter
> Email address:      traci.sumpter@opus.com.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