Changing boolean to a smallint - Mailing list pgsql-general

From Christine Penner
Subject Changing boolean to a smallint
Date
Msg-id 19740415045256.B90992D170F67E4A@edtnaa20.telusplanet.net
Whole thread Raw
Responses Re: Changing boolean to a smallint  ("Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>)
List pgsql-general
I have a table column I want to change from a boolean to a smallint.
changing false to 0 and true to 1. How do I do that?

Christine Penner
Ingenious Software
250-352-9495
chris@fp2.ca


pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Streaming replication + pgpool-II tutorial
Next
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Re: Changing boolean to a smallint