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