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

Maybe this works:

ALTER TABLE product ALTER status TYPE int USING CASE WHEN status THEN 1 ELSE
0 END;

If it doesn't, can you post the exact SQL you use and the exact error
message?

On Mon, Aug 30, 2010 at 5:27 PM, <wei725(at)lycos(dot)com> wrote:

> Unfortunately, the statement doesn't work. I get an error message about
> unable to convert boolean to integer.
>
> I have a look at the case statement for the conversion, but don't
> understand how it works.
>
>
> ----- Original Message -----
> From: "Arjen Nienhuis" <a(dot)g(dot)nienhuis(at)gmail(dot)com>
> To: wei725(at)lycos(dot)com
> Cc: pgsql-general(at)postgresql(dot)org
> 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, < wei725(at)lycos(dot)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;
>
>