Changing boolean to a smallint

From: Christine Penner <chris(at)fp2(dot)ca>
To: Postgres-General <pgsql-general(at)postgresql(dot)org>
Subject: Changing boolean to a smallint
Date: 2010-11-04 22:41:01
Message-ID: 19740415045256.B90992D170F67E4A@edtnaa20.telusplanet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)fp2(dot)ca

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2010-11-04 22:41:36 Streaming replication + pgpool-II tutorial
Previous Message David Kerr 2010-11-04 22:38:49 Re: pg_hba LDAP Authentication syntax