Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: change the last bit

Re: change the last bit

From
ljb
Date:
homecurr@yahoo.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 ...