Received: from smtp-7.ig.com.br (smtp-7.ig.com.br [200.226.132.156]) by postgresql.org (8.11.3/8.11.4) with SMTP id fB7HYsm91502 for ; Fri, 7 Dec 2001 12:34:55 -0500 (EST) (envelope-from edipoelder@ig.com.br) Message-Id: <200112071734.fB7HYsm91502@postgresql.org> Received: (qmail 1766 invoked from network); 7 Dec 2001 17:34:50 -0000 Received: from webmail-4.ig.com.br (HELO localhost) (200.225.157.200) by smtp-8.ig.com.br with SMTP; 7 Dec 2001 17:34:50 -0000 Date: Fri, 7 Dec 2001 15:34:51 -0200 To: pgsql-sql@postgresql.org From: Edipo Elder Fernandes de Melo Cc: X-Originating-IP: [200.225.157.200]200.19.175.1 X-Mailer: InMail by Insite - www.insite.com.br X-user: edipoelder@ig.com.br Subject: Just comments about math X-Archive-Number: 200112/91 X-Sequence-Number: 5914 Hi all, Why the results below are different? (On my casio scientific calculator, the two expressions below are equals to 381.4) =# select (3+0.2*707/80)*80; ?column? ---------- 381.4 =# SELECT 80*(3+(707/80)*0.2); ?column? ---------- 368 Answer: "select 707/80;" returns 8, while "select 707/80::float" returns 8.8375. Abracos, Edipo Elder [edipoelder@ig.com.br] _________________________________________________________ Oi! Você quer um iG-mail gratuito? Então clique aqui: http://registro.ig.com.br/