Sql Update Sentence

From: mariolos <mariolos(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Sql Update Sentence
Date: 2009-05-23 19:13:58
Message-ID: 10d8a0bd0905231213u70ec05ddsd1d9676b842b493@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Havasvölgyi Ottó 2009-05-23 19:14:38 Re: 8.3: timestamp subtraction
Previous Message Christophe 2009-05-23 18:50:25 Re: 8.3: timestamp subtraction