That shall work. I assume that 0 - false, 1 - true. Thank everyone for your suggestion.
----- Original Message ----- From: "Arjen Nienhuis" <[email protected]> To: [email protected] Cc: [email protected] Sent: Thursday, August 26, 2010 4:56:09 AM GMT -08:00 US/Canada Pacific Subject: Re: [GENERAL] How to convert a binary filed to an integer field? On Wed, Aug 25, 2010 at 9:29 PM, < [email protected] > wrote: I have an application in the product. Now, one status field needs to have three statuses instead of two. How to make a such change in PostgreSQL? ALTER TABLE product ALTER status TYPE int USING status::integer; -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
