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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
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-26 21:59:25
Message-ID: AANLkTi=VWksMTxNeBFHVTHQnOzSYJ6vbbPeTabOxruOe@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 25, 2010 at 1:29 PM, <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?

You could also use bitstrings.

--
To understand recursion, one must first understand recursion.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Nelson 2010-08-26 23:24:00 WAL Archive Log
Previous Message Merlin Moncure 2010-08-26 21:47:55 Re: looping on NEW and OLD in a trigger