Received: from odin.sinectis.com.ar (IDENT:root@odin.sinectis.com.ar [200.16.183.2]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA85618 for ; Fri, 7 Jan 2000 12:00:30 -0500 (EST) (envelope-from aroizen@sinectis.com.ar) Received: from sinectis.com.ar (IDENT:nobody@ix.sinectis.com.ar [200.5.70.4]) by odin.sinectis.com.ar (8.9.3/8.9.1) with ESMTP id OAA08464 for ; Fri, 7 Jan 2000 14:00:25 -0300 Sender: root@odin.sinectis.com.ar Message-ID: <38761BCA.6A931576@sinectis.com.ar> Date: Fri, 07 Jan 2000 17:00:59 +0000 From: Ana Roizen X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.5-15 i686) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@hub.org" Subject: Is there something wrong with datatype float8 ??? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello! Please, can anyone explain me why this query doesn't work? I'm using Postgres 6.51 on Linux(RedHat). Thanks a lot!! Ana Roizen Bs.As. -Argentina #--I create my table and insert some values mydb=> create table sum (x float8,y float8); CREATE mydb=> insert into sum (x,y)values(6.5,113.21); INSERT 40453062 1 #--this works fine! mydb=> select x+y from sum; ?column? -------- 173.71 (1 row) #--this doesn't work!!!! mydb=> select * from sum where x+y=173.71; x|y -+- (0 rows) mydb=> select * from sum where x+y<173.71; x| y ----+------ 60.5|113.21 (1 row) What is going wrong???