Oops; see correction below:
On 2010-11-04 16:41, Dean Gibson (DB Administrator) wrote:
On 2010-11-04 15:41, Christine Penner wrote:
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@xxxxxx
ALTER TABLE table_name ALTER col_name TYPE SMALLINT
USING CASE WHEN col_name THEN 1 ELSE 0 END;
--
Mail to my list address MUST be sent via the mailing list.
All other mail to my list address will bounce.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
