hello to all!!! i have a quiestion and problem, i need replace a value from a field with other value, i try using this sql sentence:
update packing_acum set corr=corr + 200) BETWEEN 26821 AND 27340 and extract(year from fec_prod) = 2009 AND cod_packing between 2321 and 2327 but this error appear.. ERROR: column "corr" is of type numeric but expression is of type boolean HINT: You will need to rewrite or cast the expression. ********** Error ********** ERROR: column "corr" is of type numeric but expression is of type boolean Estado SQL:42804 Sugerencias:You will need to rewrite or cast the expression. where is the problem?? thx in adv.