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@xxxxxxxxx> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
Attachment:
signature.asc
Description: Digital signature
