Postgres Pro
Downloads
Home   >   mailing lists

Re: How to convert a binary filed to an integer field? - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: How to convert a binary filed to an integer field?
Date
Msg-id 4C7571A2.1010608@iol.ie
Whole thread Raw
In response to How to convert a binary filed to an integer field?  (wei725@lycos.com)
List pgsql-general
Tree view 
On 25/08/2010 20:29, 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 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@iol.ie

pgsql-general by date:

Previous
From: wei725@lycos.com
Date:
Subject: How to convert a binary filed to an integer field?
Next
From: Adrian Klaver
Date:
Subject: Re: How to convert a binary filed to an integer field?