Re: int2+float8 problems

"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