Renaud Diez wrote:
The following bug has been logged online:
Bug reference: 3959
Logged by: Renaud Diez
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Debian
Description: Huge calculation error
Details:
the basic mathematical expression like the following one doesn't compute the
correct result:
select 100*(1+(21/100));
return a result of 100 instead of 121.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Hola, en realidad no lo hace mal, no es lo que esprabas, lo que en
realidad necesitas es esto:
select 100*(1+(21.0/100))::float;
saludos Fernando
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
