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

[Arjen Nienhuis]

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