Re: cast bool/int - Mailing list pgsql-sql

>> CASE WHEN column='t' THEN 1 ELSE 0 END
> 
> Or just CASE WHEN column THEN 1 ELSE 0 END.

In the mean time I've got an elegant solution:

alter ... ... column TYPE smallint USING column::boolean::int::smallint;

It works, you wouldn't beleive it. ;)
Zdravko