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

You are right. I typed the message in hurry before I left home this morning. It is the boolean type. Thanks for your
suggestion.The NULL value may not work for jdbc. On the application level, a fixed set of constants is used to
representthe three status, which are converted into an integer.  


----- Original Message -----
From: "Adrian Klaver" <adrian.klaver@gmail.com>
To: wei725@lycos.com
Cc: pgsql-general@postgresql.org
Sent: Wednesday, August 25, 2010 12:45:21 PM GMT -08:00 US/Canada Pacific
Subject: Re: [GENERAL] How to convert a binary filed to an integer field?

On 08/25/2010 12: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
asuch change in PostgreSQL? 
>

I am going to assume that by binary you mean boolean. If so it already
has three states NULL,True,False.

--
Adrian Klaver
adrian.klaver@gmail.com