| 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: | Whole Thread | Raw Message | 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.
| 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 |