Re: [GENERAL] Changing boolean to a smallint

2010-11-04 Thread Dean Gibson (DB Administrator)
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 25

Re: [GENERAL] Changing boolean to a smallint

2010-11-04 Thread Dean Gibson (DB Administrator)
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 ch...@fp2.ca ALTER TABLE ALTER col_name TYPE SMALLINT USING CASE WHEN col_n

[GENERAL] Changing boolean to a smallint

2010-11-04 Thread Christine Penner
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 ch...@fp2.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: