How to cast a boolean into an int2 ? - Mailing list pgsql-general

From Valerio Santinelli
Subject How to cast a boolean into an int2 ?
Date
Msg-id 36D4282F.EBABB912@mediacom.it
Whole thread Raw
List pgsql-general
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]



pgsql-general by date:

Previous
From: "Daryl W. Dunbar"
Date:
Subject: RE: [GENERAL] ISP with PostgreSQL
Next
From: Todd Graham Lewis
Date:
Subject: Re: [HACKERS] RE: [GENERAL] Transaction logging