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" <[email protected]> To: [email protected] Cc: [email protected] 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, [email protected] 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 [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
