Re: change the last bit

From: ljb <ljb220(at)mindspring(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: change the last bit
Date: 2004-07-13 01:20:30
Message-ID: ccvdct$c7e$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

homecurr(at)yahoo(dot)com wrote:
> I have a int4 coloumn, and I want to change the last bit the the
> number in this column to 0. How can I do it?

Last bit = least significant bit (LSB)?
update mytable set thecolumn = thecolumn & ~1 where ...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message raj veluchamy 2004-07-13 04:53:36 nmap not showing postgres
Previous Message Peter Eisentraut 2004-07-12 22:17:13 Re: make install (in contrib) and PGDATA