Обсуждение: 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

От
Allan Kamau
Дата:
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.