On Jul 12, 2004, at 11:07 AM, 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?
>
cfgtools=# \d delme
Table "public.delme"
Column | Type | Modifiers
--------+---------+-----------
num | integer |
cfgtools=# select * from delme;
num
-----
3
4
5
(3 rows)
cfgtools=# update delme set num = num & x'fffffffe'::int4 where num = 3;
UPDATE 1
cfgtools=# select * from delme;
num
-----
4
5
2
(3 rows)
cfgtools=#