Does anyone understand why the precedence of % is strange:test=> select -25 % -10; ?column?---------- -35(1
row)test=>select -25 % (-10); ?column?---------- -5(1 row)
Is it treating the first as -25 - 10? Why? Why are parens necessary to
get the right answer? I see this in gram.y:
%left '+' '-'%left '*' '/' '%'
Look at this:
test=> select -25 + -10; ?column?---------- -35(1 row)test=> select -25 * -10; ?column?---------- 250(1
row)test=>select -25 / -10; ?column?---------- 2(1 row)test=> select -25 % -10; ?column?---------- -35(1
row)
Only the '%' case looks wrong.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073