What do you want to change it to?
Another number? Use something like Update table set field = field + 1
I assume you are going to store the result in the same table column?
On Mon, 2004-07-12 at 13:07, [EMAIL PROTECTED] wrote:
> I have a int4 coloumn, and I want to change the last bit the the
[EMAIL PROTECTED] 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 ...
---(end of broadcast)---
