Home > mailing lists

Re: How to convert a binary filed to an integer field? - Mailing list pgsql-general

From	Arjen Nienhuis
Subject	Re: How to convert a binary filed to an integer field?
Date	August 26, 2010 11:56:19
Msg-id	AANLkTi=V-ODps60Y9Lz+L-JQsFakrvFyYE3Ly=i5qQKv@mail.gmail.com Whole thread Raw
In response to	How to convert a binary filed to an integer field? (wei725@lycos.com)
Responses	Re: How to convert a binary filed to an integer field? Re: How to convert a binary filed to an integer field?
List	pgsql-general

On Wed, Aug 25, 2010 at 9:29 PM, <wei725@lycos.com> 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;

From: Vick Khera
Date: 26 August 2010, 11:51:33
Subject: Re: Feature proposal

From: "Gnanakumar"
Date: 26 August 2010, 12:15:26
Subject: Is TRUNCATE a DML statement?