character varying as boolean !!! help
От | Francesco Andreozzi |
---|---|
Тема | character varying as boolean !!! help |
Дата | |
Msg-id | 20050113111329.M56359@proxime.it обсуждение исходный текст |
Ответы |
Re: character varying as boolean !!! help
Re: character varying as boolean !!! help |
Список | pgsql-bugs |
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 | Modificatori ------------------+-------------------+---------------------------------------------------------- cod_cfp | integer | not null default nextval('public.cfp_cod_cfp_seq'::text) cod_procedimento | bigint | testo | character varying | 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" ????????????????? so i've try to update with a boolean value, just for test and offcourse ..... sportellounico=# UPDATE cfp SET testo=true AND cod_procedimento='82' where cod_cfp='2'; ERROR: column "testo" is of type character varying but expression is of type boolean I've try to drop the field and recreate... but nothing... any suggestion? Thankyou Francesco -- Francesco Andreozzi Tel. 347-3757481
В списке pgsql-bugs по дате отправления: