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]