Hello,

you could check for indices or something like that.

Björn

Am 25.09.2011 um 17:17 schrieb Edson Carlos Ericksson Richter:

> Dear list,
>  
> I’ve a strange issue here. I’ve a table that I’m sure the column type is 
> boolean. I can see the datatype is boolean on PgAdmin.
>  
> Nevertheless, when I issue this command
> --------------------------------------------------------------------------------
> alter table usuario alter column ativo type smallint using (case when ativo 
> then 1 else 0 end);
> --------------------------------------------------------------------------------
>  
> I get the following error:
> --------------------------------------------------------------------------------
> ERROR:  argument of IS FALSE must be type boolean, not type smallint
>  
> ********** Error **********
>  
> ERROR: argument of IS FALSE must be type boolean, not type smallint
> SQL state: 42804
> --------------------------------------------------------------------------------
>  
> I already run Vacuum just to be sure, but still not working.
>  
> I have a script with hundred similar lines (for other tables) without any 
> error, just this table.
>  
> Any hints?
>  
>  
> Edson Carlos Ericksson Richter 
> SimKorp Infomática Ltda
> Fone:
> (51) 3366-7964
> Celular:
> (51) 8585-0796
> <image001.jpg>
> www.simkorp.com.br
>  


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to