Postgres Pro
Downloads
Home   >   mailing lists

Re: count the number of bits set to 1 in a bit string field - Mailing list pgsql-general

From Rajarshi Guha
Subject Re: count the number of bits set to 1 in a bit string field
Date
Msg-id A33C5957-28B2-448D-A796-B96160C2CF63@indiana.edu
Whole thread Raw
In response to Re: count the number of bits set to 1 in a bit string field  (Ragnar <gnari@hive.is>)
List pgsql-general
Tree view 
On Jul 15, 2007, at 7:20 PM, Ragnar wrote:

> On sun, 2007-07-15 at 15:35 -0400, Rajarshi Guha wrote:
>> Hi, is there a built in function that will give me the number of bits
>> that are set to 1 in a bit string field?
>
> no, but it should be trivial to do with pl/pgsql

Thanks for the pointer

-------------------------------------------------------------------
Rajarshi Guha  <rguha@indiana.edu>
GPG Fingerprint: 0CCA 8EE2 2EEB 25E2 AB04  06F7 1BB9 E634 9B87 56EE
-------------------------------------------------------------------
Gravity brings me down.

pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: Re: Weird error message in SQL function call
Next
From: tabai
Date:
Subject: Re: Limit number connections by IP