Skip site navigation (1) Skip section navigation (2)

Re: character varying as boolean !!! help

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 (view raw or flat)
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)

In response to

pgsql-bugs by date

Next:From: Richard HuxtonDate: 2005-01-13 13:44:25
Subject: Re: character varying as boolean !!! help
Previous:From: laurie.burrowDate: 2005-01-13 12:48:37
Subject: Possible problem with pg_get_viewdef on Postgres V8.0.0 rc4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group