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

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: wei725(at)lycos(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to convert a binary filed to an integer field?
Date: 2010-08-25 19:40:18
Message-ID: 4C7571A2.1010608@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 25/08/2010 20:29, 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?

Perhaps an enumerated type?

http://www.postgresql.org/docs/8.4/static/datatype-enum.html

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2010-08-25 19:45:21 Re: How to convert a binary filed to an integer field?
Previous Message wei725 2010-08-25 19:29:21 How to convert a binary filed to an integer field?