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 [[EMAIL PROTECTED]]+:+[http://www.mediacom.it/~tanis]