Home > mailing lists

How to count ones in a bit string? - Mailing list pgsql-novice

From	Cheng
Subject	How to count ones in a bit string?
Date	February 21, 2012 14:33:13
Msg-id	4F43B923.1010402@gmail.com Whole thread Raw
Responses	Re: How to count ones in a bit string? (Richard Broersma <richard.broersma@gmail.com>)
List	pgsql-novice

Tree view

For example, I have a bit string as:

B'101000000000000000000010'

How do I count the number of ones in it? In this example, it is 3.

Thanks,
Cheng

pgsql-novice by date:

From: Ganesh Borse
Date: 20 February 2012, 06:22:48
Subject: Request for help on selecting bytea columns using ODBC (windows) from Postgresql DB

From: Richard Broersma
Date: 21 February 2012, 14:44:38
Subject: Re: How to count ones in a bit string?

How to count ones in a bit string? - Mailing list pgsql-novice

Previous

Next