How to cast a boolean into an int2 ?

How do I cast a boolean into an int2 ?

I want to do something like:

INSERT INTO test SELECT id, (demo='t') from temp;

but the second field isn't a boolean in the "test" table but an int2.


--

C'ya!

Valerio Santinelli a.k.a. TANiS
[tanis@mediacom.it]+:+[http://www.mediacom.it/~tanis]