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

There are probably fast better ways. But this is one way:

postgres=> SELECT LENGTH( REPLACE( CAST( B'101000000000000000000010'
AS TEXT ), '0', ''));
 length
--------
      3

On Tue, Feb 21, 2012 at 7:32 AM, Cheng <niechenghust@gmail.com> wrote:
> 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
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice



--
Regards,
Richard Broersma Jr.