Re: int2+float8 problems

compile   ./configure  --prefix=/home/pgsql --enable-multibyte
run Redhat 6.1 & 6.2
postgresql7.0.3
not run regression tests






"Tom Lane" <tgl@sss.pgh.pa.us> ���g���l��
news:19717.983412113@sss.pgh.pa.us...
> "guard" <guard@ficnet.net> 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