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.kla...@gmail.com> To: wei...@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, 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? > I am going to assume that by binary you mean boolean. If so it already has three states NULL,True,False. -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
