Re:Re: Substraction

2003-01-20 Thread Nasser Ossareh
> 1. Check if you really need an unsigned column - if not just alter the column to >signed this is the most appropriate answer. i.e your table design should cater for the "limited set" or "modulus" arithmatics. Casting wouldn't work simply because you may really want the actual unsigned val

Re: Re:Re: Substraction

2003-01-19 Thread Adolfo Bello
On Sun, 2003-01-19 at 19:09, Nasser Ossareh wrote: > Isn't there a typo somewhere... > Shouldn't you expect 5 instead of -5 (15 - id where id = 10)?? > > Nevermind, let's assume that there is a typo somewhere and the correct expected >value is -5... however, in the domain of unsigned arithmet

Re:Re: Substraction

2003-01-19 Thread Nasser Ossareh
Isn't there a typo somewhere... Shouldn't you expect 5 instead of -5 (15 - id where id = 10)?? Nevermind, let's assume that there is a typo somewhere and the correct expected value is -5... however, in the domain of unsigned arithmetics -5 is precisely 18446744073709551611... don't you belie