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 represent the three status, which are converted into an integer. ----- Original Message ----- From: "Adrian Klaver" <adrian.klaver@xxxxxxxxx> To: wei725@xxxxxxxxx Cc: pgsql-general@xxxxxxxxxxxxxx Sent: Wednesday, August 25, 2010 12:45:21 PM GMT -08:00 US/Canada Pacific Subject: Re: How to convert a binary filed to an integer field? On 08/25/2010 12: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? > 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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
