Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g124eHl29784 for ; Fri, 1 Feb 2002 23:40:17 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g124dFf14775; Fri, 1 Feb 2002 23:39:15 -0500 (EST) To: pocm@rnl.ist.utl.pt (Paulo J. Matos) cc: pgsql-sql@postgresql.org Subject: Re: Fractional Results In-reply-to: <874rl0y8pq.fsf@localhost.localdomain> References: <874rl0y8pq.fsf@localhost.localdomain> Comments: In-reply-to pocm@rnl.ist.utl.pt (Paulo J. Matos) message dated "02 Feb 2002 01:26:57 +0000" Date: Fri, 01 Feb 2002 23:39:15 -0500 Message-ID: <14772.1012624755@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200202/33 X-Sequence-Number: 6465 pocm@rnl.ist.utl.pt (Paulo J. Matos) writes: > After some testing i found out that temp1.espl / temp2.iluminados > gives us always the floor of the real value. If these are integers, try casting them to floats before dividing. Integer division is generally understood to yield the floor(). regards, tom lane