Postgres Pro
Downloads
Home   >   mailing lists

Thread: Efficiently determining the number of bits set in the contents of a VARBIT field

Efficiently determining the number of bits set in the contents of a VARBIT field

From
Allan Kamau
Date:
Hi all,
Am looking for a fast and efficient way to count the number of bits set 
(to 1) in a VARBIT field. I am currently using 
"LENGTH(REGEXP_REPLACE(CAST(a.somefield_bit_code AS TEXT),'0','','g'))".

Allan.