Re: Sql Update Sentence

On Sat, May 23, 2009 at 03:13:58PM -0400, 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:
>
> 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 **********

There's a syntax error in your statement, so please send what the
actual query is. But if I imagine an extra brace then it's true that
you're trying to assign a boolean to a numeric:

a BETWEEN b AND c

is a boolean expression.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.