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 (<[EMAIL PROTECTED]>)
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)

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to