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