Re: change the last bit

On Jul 12, 2004, at 11:07 AM, 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?
>

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=#