Re: [BUGS] character varying as boolean !!! help

2005-01-13 Thread Richard Huxton
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 A

Re: [BUGS] character varying as boolean !!! help

2005-01-13 Thread Alvaro Herrera
On Thu, Jan 13, 2005 at 12:18:12PM +0100, Francesco Andreozzi wrote: Hi, > Tabella "public.cfp" > Colonna | Tipo| Modificatori > --+---+-