GETBIT Function

Return the bit value (0 or 1) in a number at the specified position, according to the binary representation of that number.

getbit(target_number, bit_position)
target_number
A specific number or an expression that evaluates to a number. The number must be a SMALLINT, INT, or BIGINT data type.
bit_position
Bit position in the target number. The position must be an integer that is in range for the size of the target number. For example, if the target is a 16-bit data type, the position must be between 0 and 15. For a 32-bit data type, the position must be between 0 and 31.
For example:
premdb=# select htid, getbit(htid,2) from team;
 htid | getbit 
------+--------
    2 |      0
    3 |      0
    4 |      1
    5 |      1
    6 |      1
    7 |      1
    8 |      0
    9 |      0
   10 |      0
...
premdb=# select getbit(987654321,31) from sys.const;
 getbit 
--------
      0
(1 row)