int2+float8 problems

From: "guard" <guard(at)ficnet(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: int2+float8 problems
Date: 2001-03-01 00:48:09
Message-ID: 97k5le$21sk$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Justin Clift 2001-03-01 01:59:38 Help needed -> ERROR: record arow has no field description
Previous Message Kyle 2001-02-28 23:34:40 Re: Daily Digest V1 #282