>> 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