Francesco Andreozzi wrote:
>
> if I try to insert something it works.... but the update no....
>
> sportellounico=# UPDATE cfp SET testo='test' AND cod_procedimento='82' where
> cod_cfp='2';
> ERROR: invalid input syntax for type boolean: "test"
The error message is misleading you here. You want a comma not AND
above. The parser is reading that as:
UPDATE cfp SET testo=('test' AND cod_procedimento='82')
--
Richard Huxton
Archonet Ltd