Received: from xyzzy.lan.internal (d226-86-192.home.cgocable.net [24.226.86.192]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBAFCjm49156 for ; Mon, 10 Dec 2001 10:12:46 -0500 (EST) (envelope-from drew@xyzzy.dhs.org) Received: from localhost ([127.0.0.1] helo=there ident=drew) by xyzzy.lan.internal with smtp (Exim 3.33 #1 (Debian)) id 16DS6k-0000ay-00; Mon, 10 Dec 2001 10:12:42 -0500 Content-Type: text/plain; charset="iso-8859-1" From: "Andrew G. Hammond" To: Edipo Elder Fernandes de Melo , pgsql-sql@postgresql.org Subject: Re: Just comments about math Date: Mon, 10 Dec 2001 10:12:34 -0500 X-Mailer: KMail [version 1.3.2] References: <200112071734.fB7HYsm91502@postgresql.org> In-Reply-To: <200112071734.fB7HYsm91502@postgresql.org> MIME-Version: 1.0 Message-Id: Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id fBAFIhL50093 X-Archive-Number: 200112/93 X-Sequence-Number: 5916 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 2001 December 7 12:34 pm, Edipo Elder Fernandes de Melo wrote: > =# 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. SELECT 707.0/80; --> 8.8375 In your first expression, you change type to floating point in your first operation, but in your second expression you don't change type until the second to last operation. Integer division always returns an integer result, even when it's not the most mathematically intuitive way to do things. - -- Andrew G. Hammond mailto:drew@xyzzy.dhs.org http://xyzzy.dhs.org/~drew/ 56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481 5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1 "To blow recursion you must first blow recur" -- me -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iEYEARECAAYFAjwU0OcACgkQCT73CrRXhLFZBwCgjBrPcSCzGKkf91KEstX4F68G SbcAniakO7mr044HoJtegKn8vdX/gWfE =PlV9 -----END PGP SIGNATURE-----