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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to