[GENERAL] How to clear bits?

[madhtr]

Hello group :)

How do a clear bits in a number in PostGreSQL?

in c++ its:

0xffffff00 &~ 0x0000ffff

what is it in PostGreSQL from the psql command line app?

select ...

Thanx:)


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match