Re: How to convert a binary filed to an integer field?

[Arjen Nienhuis <a.g.nienhuis@xxxxxxxxx>]

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