Re: [SQL] int2+float8 problems

[Tom Lane]

"guard" <[EMAIL PROTECTED]> 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