Hello!
I ran the query
update producers SET cor_id = producer_id % 9 + 1;
and found that result is eqiuvalent to
update producers SET cor_id = producer_id % 9;
I added parens:
update producers SET cor_id = (producer_id % 9) + 1;
and got what I needed.
Is it a bug, a feature, or I just misinterpreted the syntax?
Oleg.
---- Oleg Broytmann http://members.xoom.com/phd2/ phd2@earthling.net Programmers don't die, they
justGOSUB without RETURN.
