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.
