Re: [SQL] int2+float8 problems

"guard" wrote: >select trn_qty,amount2,trn_qty*amount2 from invo > >trn_qty INT2 >amount2 FLOAT8 > >+-+-+--+ >| trn_qty | amount2 | ?column? | >+-+-+--+ >| -1 |7678 | 7678 | > >what to get -7678 This works in 7.1be

Re: [SQL] 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" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > "guard" <[EMAIL PROTECTED]> writes: > > select trn_qty,amount2,trn_qty*amount2

Re: [SQL] int2+float8 problems

"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

[SQL] int2+float8 problems

select trn_qty,amount2,trn_qty*amount2 from invo trn_qty INT2 amount2 FLOAT8 +-+-+--+ | trn_qty | amount2 | ?column? | +-+-+--+ | -1 |7678 | 7678 | what to get -7678 thanks