Postgres Pro
Downloads
Home   >   mailing lists

Re: change the last bit - Mailing list pgsql-general

From ljb
Subject Re: change the last bit
Date
Msg-id ccvdct$c7e$1@news.hub.org
Whole thread Raw
List pgsql-general
Tree view 
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 ...

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: make install (in contrib) and PGDATA
Next
From: "Najib Abi Fadel"
Date:
Subject: function returning a readable representation of a number