hola a todos,, tengo un problema al tratar de reemplazar datos de un campo
desde el pgadmin, estoy usando esta sentencia

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

y me da este error

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.

alguien sabra donde esta el problema?

Gracias.

Responder a