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(at)sss(dot)pgh(dot)pa(dot)us> gl
news:19717(dot)983412113(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> "guard" <guard(at)ficnet(dot)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