Sql Update Sentence
| От | mariolos |
|---|---|
| Тема | Sql Update Sentence |
| Дата | |
| Msg-id | 10d8a0bd0905231213u70ec05ddsd1d9676b842b493@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Sql Update Sentence
Re: Sql Update Sentence |
| Список | 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.
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.
В списке pgsql-general по дате отправления: