Re: Sql Update Sentence

On Saturday 23 May 2009 12:13:58 pm mariolos wrote:
> 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:

Is this the entire actual SQL statement? If so see below.

>
> update packing_acum set corr=corr + 200) BETWEEN 26821 AND 27340 and
                                      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
First no left parentheses. Second the BETWEEN clause is operating on corr + 200
and resolving to true or false which is the being used to update corr. Since
corr is numeric the update fails.

> 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.



--
Adrian Klaver
aklaver@comcast.net