Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f215Tkx67743 for ; Thu, 1 Mar 2001 00:29:46 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f215M1s71099 for pgsql-sql@postgresql.org; Thu, 1 Mar 2001 00:22:01 -0500 (EST) (envelope-from news) From: "guard" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: int2+float8 problems Date: Thu, 1 Mar 2001 13:19:19 +0800 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 28 Message-ID: <97km9f$25dm$1@news.tht.net> References: <19717.983412113@sss.pgh.pa.us> X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 To: pgsql-sql@postgresql.org X-Archive-Number: 200103/2 X-Sequence-Number: 1643 compile ./configure --prefix=/home/pgsql --enable-multibyte run Redhat 6.1 & 6.2 postgresql7.0.3 not run regression tests "Tom Lane" ¼¶¼g©ó¶l¥ó news:19717.983412113@sss.pgh.pa.us... > "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