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]
