Re: SELECT subtraction issue
Posted by:
Andy CLyde
Date: January 12, 2006 06:21AM
I hate it when I answer my own posts!
Turns out this is a casting issue.
If one of the fields used in subtraction is unsigned then then the result is unsigned.
CASTing the result to a SIGNED integer solves the problem!
Subject
Views
Written By
Posted
9171
January 12, 2006 05:49AM
Re: SELECT subtraction issue
2798
January 12, 2006 06:21AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.