How to cast a boolean into an int2 ?

Started by Valerio Santinelliabout 27 years ago1 messagesgeneral
Jump to latest
#1Valerio Santinelli
tanis@mediacom.it

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]