From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
---|---|
To: | Francesco Andreozzi <francesco(dot)andreozzi(at)proxime(dot)it> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: character varying as boolean !!! help |
Date: | 2005-01-13 12:54:13 |
Message-ID: | 20050113125413.GB23993@dcc.uchile.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Thu, Jan 13, 2005 at 12:18:12PM +0100, Francesco Andreozzi wrote:
Hi,
> 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"
Do you have any trigger or rule on this table?
--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
Oh, oh, las chicas galacianas, lo harán por las perlas,
¡Y las de Arrakis por el agua! Pero si buscas damas
Que se consuman como llamas, ¡Prueba una hija de Caladan! (Gurney Halleck)
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2005-01-13 13:44:25 | Re: character varying as boolean !!! help |
Previous Message | laurie.burrow | 2005-01-13 12:48:37 | Possible problem with pg_get_viewdef on Postgres V8.0.0 rc4 |