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 > --+---+-

[BUGS] character varying as boolean !!! help

2005-01-13 Thread Francesco Andreozzi
I think thi is a bug, I've a lot of db up with same structure and I don't have any prioblem.. I'm using psql 7.4.2 the problem is that i've a table sportellounico=# \d cfp Tabella "public.cfp" Colonna | Tipo| Modi