Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f21222x49393 for ; Wed, 28 Feb 2001 21:02:02 -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.1/8.11.1) with ESMTP id f2121r919720; Wed, 28 Feb 2001 21:01:54 -0500 (EST) To: "guard" cc: pgsql-sql@postgresql.org Subject: Re: int2+float8 problems In-reply-to: <97k5le$21sk$1@news.tht.net> References: <97k5le$21sk$1@news.tht.net> Comments: In-reply-to "guard" message dated "Thu, 01 Mar 2001 08:48:09 +0800" Date: Wed, 28 Feb 2001 21:01:53 -0500 Message-ID: <19717.983412113@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/434 X-Sequence-Number: 1639 "guard" writes: > select trn_qty,amount2,trn_qty*amount2 from invo > trn_qty INT2 > amount2 FLOAT8 > +---------+---------+----------+ > | trn_qty | amount2 | ?column? | > +---------+---------+----------+ > | -1 | 7678 | 7678 | What platform are you on, and how did you compile Postgres? Also, what Postgres version? Did you run the regression tests? regards, tom lane